Meeting Title: Wholesale Customers Topic Development Sync Date: 2026-03-18 Meeting participants: Awaish Kumar, Mustafa Raja
WEBVTT
1 00:00:42.570 ⇒ 00:00:43.500 Mustafa Raja: Hey.
2 00:00:45.900 ⇒ 00:00:48.880 Awaish Kumar: Hi, okay, yeah, what I wanted to do is basically…
3 00:00:49.530 ⇒ 00:00:52.090 Awaish Kumar: I saw Yadhu, that, like, you…
4 00:00:52.880 ⇒ 00:00:58.080 Awaish Kumar: And, Amber added some topics for… Element?
5 00:00:58.760 ⇒ 00:00:59.520 Mustafa Raja: Yeah.
6 00:01:01.960 ⇒ 00:01:07.389 Awaish Kumar: Yeah, like, for example, I… I can see this topic, like,
7 00:01:07.890 ⇒ 00:01:12.580 Awaish Kumar: Is wholesale, like, is wholesale a topic, or wholesale customer is a topic?
8 00:01:12.580 ⇒ 00:01:26.889 Mustafa Raja: The wholesale… this wholesale is a folder, and then, wholesale customers, and wholesale partner, funnel base, yeah, that… those are topics. The wholesale itself isn’t a topic, that’s a folder.
9 00:01:27.470 ⇒ 00:01:28.310 Awaish Kumar: Oh, great.
10 00:01:28.990 ⇒ 00:01:30.520 Awaish Kumar: Wholesale customers.
11 00:01:31.550 ⇒ 00:01:33.890 Awaish Kumar: Okay, and if I want to…
12 00:01:34.590 ⇒ 00:01:39.060 Awaish Kumar: now I want to edit this so I can include… okay, like, do you know if…
13 00:01:39.470 ⇒ 00:01:45.860 Awaish Kumar: If our topics have one-to-many relationships, if we add data into same topic, that it works.
14 00:01:46.200 ⇒ 00:01:52.279 Awaish Kumar: For example, this… we have a topic for customers. This is only information related to one customer.
15 00:01:52.550 ⇒ 00:01:55.390 Awaish Kumar: Like, single row, one row for one customer.
16 00:01:55.640 ⇒ 00:01:58.950 Awaish Kumar: Now I have a table, which is, like, for orders.
17 00:01:59.220 ⇒ 00:02:02.349 Awaish Kumar: And one customer can have multiple orders.
18 00:02:02.480 ⇒ 00:02:03.370 Mustafa Raja: Yes.
19 00:02:03.370 ⇒ 00:02:03.730 Awaish Kumar: I’m both…
20 00:02:03.730 ⇒ 00:02:05.920 Mustafa Raja: Yes, we can add that in the topic, yes.
21 00:02:06.310 ⇒ 00:02:10.860 Awaish Kumar: So, yeah, and then following that, like, I also have a… Come on.
22 00:02:11.150 ⇒ 00:02:13.660 Awaish Kumar: Orderline topic, so…
23 00:02:15.970 ⇒ 00:02:21.499 Awaish Kumar: One customer can have multiple orders, but a single order then can have multiple order line items.
24 00:02:22.010 ⇒ 00:02:23.320 Awaish Kumar: Like, multiple products.
25 00:02:23.320 ⇒ 00:02:28.399 Mustafa Raja: can have single order, and then order have multiple order lines. That’s correct, right?
26 00:02:28.400 ⇒ 00:02:30.630 Awaish Kumar: Yeah, one customer can have multiple orders.
27 00:02:30.880 ⇒ 00:02:31.909 Mustafa Raja: Okay, okay.
28 00:02:31.910 ⇒ 00:02:36.959 Awaish Kumar: And then I… And each order can have multiple items in it, right?
29 00:02:37.330 ⇒ 00:02:41.390 Mustafa Raja: Yes, yes, yes, we can add that in the… in the topic also, yeah.
30 00:02:42.020 ⇒ 00:02:44.280 Awaish Kumar: For that, we should go to…
31 00:02:44.680 ⇒ 00:02:47.410 Mustafa Raja: We should go to Develop. Let’s go to Develop.
32 00:02:50.570 ⇒ 00:02:51.740 Awaish Kumar: Develop.
33 00:02:52.430 ⇒ 00:02:58.539 Mustafa Raja: And then, yeah, here, and then let’s find the topic. So, in wholesale folder, yeah, in customer, yeah.
34 00:02:59.310 ⇒ 00:03:06.479 Mustafa Raja: And then, here we would want to first include the views.
35 00:03:06.700 ⇒ 00:03:18.229 Mustafa Raja: Right? So we would want to add the tables here, and then in the relationships, in the settings, you’d say relationships, right? We can create relationships here.
36 00:03:19.300 ⇒ 00:03:29.759 Mustafa Raja: Or you could edit this topic in workbook, and then they have a… they have a visual way of, adding joins.
37 00:03:32.580 ⇒ 00:03:35.870 Mustafa Raja: So, you see the Joins tab here?
38 00:03:36.810 ⇒ 00:03:37.760 Awaish Kumar: Oh, okay.
39 00:03:38.800 ⇒ 00:03:43.429 Mustafa Raja: And then… and then, yeah, so new… you can create a new join from here.
40 00:03:44.040 ⇒ 00:03:48.090 Mustafa Raja: Yeah, and then… That’s how it goes.
41 00:03:49.440 ⇒ 00:03:58.810 Awaish Kumar: DIM customer, basically… Okay… It joins with relationship.
42 00:04:00.110 ⇒ 00:04:00.750 Awaish Kumar: In one?
43 00:04:00.750 ⇒ 00:04:01.440 Mustafa Raja: Yeah.
44 00:04:01.440 ⇒ 00:04:06.610 Awaish Kumar: Customer can have many… Orders, right?
45 00:04:07.310 ⇒ 00:04:08.180 Mustafa Raja: Yes.
46 00:04:08.360 ⇒ 00:04:13.160 Awaish Kumar: I just… Wholesale.
47 00:04:13.430 ⇒ 00:04:19.890 Awaish Kumar: Perfect orders… And we have to select the… Customer ID.
48 00:04:21.240 ⇒ 00:04:22.160 Mustafa Raja: Yeah.
49 00:04:22.990 ⇒ 00:04:27.840 Mustafa Raja: Did we select, an ID on the, on the DIM customers?
50 00:04:29.500 ⇒ 00:04:32.120 Awaish Kumar: Same. Okay.
51 00:04:33.610 ⇒ 00:04:36.010 Mustafa Raja: Okay, yeah, let’s add this.
52 00:04:36.010 ⇒ 00:04:41.190 Awaish Kumar: can have multiple orders, and this is one-to-many. That’s right, right?
53 00:04:41.490 ⇒ 00:04:43.449 Mustafa Raja: Yeah, this is… this is correct, yeah.
54 00:04:43.830 ⇒ 00:04:48.590 Awaish Kumar: And left join means we only have the data from Difficult.
55 00:04:48.590 ⇒ 00:04:50.989 Mustafa Raja: From the, customers table, yeah.
56 00:04:51.040 ⇒ 00:04:51.750 Awaish Kumar: Okay.
57 00:04:53.760 ⇒ 00:04:56.709 Mustafa Raja: And then, let’s, let’s add another one.
58 00:04:59.200 ⇒ 00:05:10.290 Mustafa Raja: For the line thing, and here we would want to… we would want to change… this… this new join would be from orders to some… something else, right? So in the left side, we’d want orders then, right?
59 00:05:10.290 ⇒ 00:05:12.670 Awaish Kumar: Yeah, but I have the customer ID also here.
60 00:05:13.060 ⇒ 00:05:15.579 Mustafa Raja: Oh, oh, yeah, that’s fine then, yeah, okay, okay.
61 00:05:15.580 ⇒ 00:05:17.070 Awaish Kumar: But in that case.
62 00:05:17.830 ⇒ 00:05:24.369 Awaish Kumar: if I join it on customer ID, it will… all line items will go there. Oh, okay, I should join it with the orders, basically.
63 00:05:24.370 ⇒ 00:05:25.189 Mustafa Raja: Yeah, yeah.
64 00:05:25.490 ⇒ 00:05:29.070 Mustafa Raja: Let’s find orders here, and then we can work with that, yeah.
65 00:05:31.780 ⇒ 00:05:32.490 Awaish Kumar: Okay.
66 00:05:33.600 ⇒ 00:05:36.439 Awaish Kumar: And… I have what?
67 00:05:37.280 ⇒ 00:05:44.930 Awaish Kumar: Auto ID… Same, like… Auto ID.
68 00:05:45.970 ⇒ 00:05:49.880 Awaish Kumar: And one same relationship, one to many, what order?
69 00:05:50.310 ⇒ 00:05:52.490 Awaish Kumar: Can have multiple items in it.
70 00:05:54.380 ⇒ 00:05:56.429 Awaish Kumar: Yeah, that’s join. Okay.
71 00:05:57.250 ⇒ 00:05:58.090 Awaish Kumar: Okay.
72 00:05:59.670 ⇒ 00:06:00.420 Awaish Kumar: Great.
73 00:06:02.070 ⇒ 00:06:02.630 Awaish Kumar: Si.
74 00:06:02.630 ⇒ 00:06:04.240 Mustafa Raja: Good to see you. Yeah.
75 00:06:04.550 ⇒ 00:06:05.240 Awaish Kumar: Okay.
76 00:06:08.410 ⇒ 00:06:10.960 Mustafa Raja: Okay, let’s go back in the topic view.
77 00:06:12.240 ⇒ 00:06:18.239 Mustafa Raja: In, in, in model. Oh, sorry, in develop, and then let’s see if… if the relationships are there, you know.
78 00:06:25.320 ⇒ 00:06:27.020 Mustafa Raja: In wholesale…
79 00:06:32.130 ⇒ 00:06:33.759 Awaish Kumar: Okay, I can’t see it here.
80 00:06:47.800 ⇒ 00:06:51.140 Mustafa Raja: Yeah, let’s go back and, I did.
81 00:06:51.820 ⇒ 00:06:56.120 Mustafa Raja: We did see… Let’s go into the joins, if the joins are there.
82 00:06:58.880 ⇒ 00:07:02.090 Awaish Kumar: That doesn’t seem like… Okay.
83 00:07:02.770 ⇒ 00:07:03.780 Awaish Kumar: Why?
84 00:07:05.140 ⇒ 00:07:12.240 Mustafa Raja: It might have, do we have, have we attached, what’s it called, the GitHub repo?
85 00:07:14.590 ⇒ 00:07:15.539 Awaish Kumar: I have what?
86 00:07:16.470 ⇒ 00:07:18.919 Mustafa Raja: Have we attached this to the Git?
87 00:07:20.570 ⇒ 00:07:22.020 Awaish Kumar: I don’t think so.
88 00:07:22.300 ⇒ 00:07:23.590 Awaish Kumar: I didn’t, so I…
89 00:07:25.830 ⇒ 00:07:33.340 Mustafa Raja: Okay, because, if it is, then we’ll only be able to work in what’s it called? .
90 00:07:33.340 ⇒ 00:07:37.019 Awaish Kumar: We haven’t done it here, but there was other place also.
91 00:07:37.530 ⇒ 00:07:41.760 Mustafa Raja: Yeah, yeah, in the model, in the develop, right. We did, I think we did in the develop.
92 00:07:43.110 ⇒ 00:07:45.430 Awaish Kumar: No, I’ll remove that part.
93 00:07:45.770 ⇒ 00:07:50.690 Mustafa Raja: Okay, okay, okay.
94 00:07:51.000 ⇒ 00:07:51.610 Awaish Kumar: No.
95 00:07:51.610 ⇒ 00:08:00.269 Mustafa Raja: Okay, yeah, let’s, let’s just try again, see, see, we might have missed something.
96 00:08:02.470 ⇒ 00:08:04.260 Awaish Kumar: Okay, let’s go back to…
97 00:08:05.050 ⇒ 00:08:08.670 Mustafa Raja: Let’s, let’s create those joins again in the UI.
98 00:08:13.880 ⇒ 00:08:15.189 Awaish Kumar: Okay.
99 00:08:25.240 ⇒ 00:08:28.710 Awaish Kumar: You, fair.
100 00:08:28.710 ⇒ 00:08:30.550 Mustafa Raja: Or, I can get everyone else.
101 00:08:30.980 ⇒ 00:08:38.009 Awaish Kumar: Where’s… customer ID… Customer ID, no.
102 00:08:39.929 ⇒ 00:08:44.269 Awaish Kumar: too many… One to many… one 20. Okay.
103 00:08:44.920 ⇒ 00:08:45.840 Awaish Kumar: Ed.
104 00:08:46.410 ⇒ 00:08:49.360 Awaish Kumar: Let’s… let’s just confirm that.
105 00:08:50.890 ⇒ 00:08:52.650 Awaish Kumar: It says topic updated.
106 00:08:53.100 ⇒ 00:08:55.170 Mustafa Raja: Let’s go into the overview also.
107 00:08:56.810 ⇒ 00:08:57.340 Awaish Kumar: Oh, it is.
108 00:08:57.340 ⇒ 00:09:01.190 Mustafa Raja: Here, I want to see, yeah, if in the overview…
109 00:09:02.690 ⇒ 00:09:08.060 Mustafa Raja: Okay, this says that… okay, this is a preview represented in UI.
110 00:09:08.510 ⇒ 00:09:09.999 Awaish Kumar: Yeah, so that’s okay.
111 00:09:11.100 ⇒ 00:09:13.129 Awaish Kumar: I can maybe open it in the…
112 00:09:17.400 ⇒ 00:09:23.770 Mustafa Raja: Oh, wait, wait a minute. Can you say that? Can you go back?
113 00:09:24.520 ⇒ 00:09:25.780 Awaish Kumar: Yeah, yeah, you list.
114 00:09:26.140 ⇒ 00:09:28.160 Mustafa Raja: Let’s go back to the other window.
115 00:09:29.450 ⇒ 00:09:31.700 Mustafa Raja: Can you click this?
116 00:09:33.310 ⇒ 00:09:34.590 Mustafa Raja: On the top left.
117 00:09:36.800 ⇒ 00:09:39.079 Mustafa Raja: Yeah, we have to promote it from here, yeah.
118 00:09:40.960 ⇒ 00:09:45.569 Mustafa Raja: Okay, we can promote it from here, and those should get promoted.
119 00:09:45.910 ⇒ 00:09:46.490 Awaish Kumar: like…
120 00:09:46.970 ⇒ 00:09:48.319 Mustafa Raja: Yeah, yeah, this button, yeah.
121 00:09:49.570 ⇒ 00:09:51.340 Awaish Kumar: And what is this? Okay.
122 00:09:51.340 ⇒ 00:09:55.640 Mustafa Raja: This’ll just, this, this’ll just, update the main topic.
123 00:09:56.280 ⇒ 00:09:57.919 Mustafa Raja: These aren’t getting updated.
124 00:09:59.290 ⇒ 00:10:02.560 Mustafa Raja: Yeah, now if you refresh it, you’d see the join.
125 00:10:04.660 ⇒ 00:10:06.110 Mustafa Raja: You see? Joins.
126 00:10:06.280 ⇒ 00:10:06.990 Awaish Kumar: Okay.
127 00:10:06.990 ⇒ 00:10:11.440 Mustafa Raja: And then in the Relationships tab, you’d see actual relationship build, you know?
128 00:10:11.690 ⇒ 00:10:12.930 Mustafa Raja: Here, yeah.
129 00:10:14.480 ⇒ 00:10:17.290 Mustafa Raja: So, we already have a few… yeah, this one, I think.
130 00:10:17.870 ⇒ 00:10:19.840 Mustafa Raja: Oh, nice. Okay, let’s add the other one.
131 00:10:21.550 ⇒ 00:10:26.400 Awaish Kumar: Okay, let’s scroll back… I’m joined.
132 00:10:29.480 ⇒ 00:10:31.579 Mustafa Raja: Now we want order from items, right?
133 00:10:32.690 ⇒ 00:10:33.640 Awaish Kumar: Yes.
134 00:10:35.220 ⇒ 00:10:44.960 Awaish Kumar: vector orders, and the… Order items… Should have order ID?
135 00:10:46.200 ⇒ 00:10:52.880 Awaish Kumar: Quarter ID… Okay… Oh, we don’ Daps
136 00:10:56.170 ⇒ 00:10:56.850 Awaish Kumar: Okay…
137 00:10:56.850 ⇒ 00:10:59.270 Mustafa Raja: Okay, let’s save, and then let’s promote.
138 00:11:04.410 ⇒ 00:11:06.420 Mustafa Raja: Yeah, let’s, let’s check.
139 00:11:11.530 ⇒ 00:11:13.310 Mustafa Raja: Yeah, this is good booking.
140 00:11:14.930 ⇒ 00:11:15.730 Awaish Kumar: And then…
141 00:11:20.880 ⇒ 00:11:23.479 Awaish Kumar: Okay, this… This got added.
142 00:11:24.190 ⇒ 00:11:25.020 Mustafa Raja: Yeah.
143 00:11:25.380 ⇒ 00:11:25.960 Awaish Kumar: Okay.
144 00:11:26.330 ⇒ 00:11:30.559 Awaish Kumar: Great, so we can now… Basically, go back.
145 00:11:31.900 ⇒ 00:11:41.570 Awaish Kumar: into the… Do a little… Into… And the topic…
146 00:11:46.580 ⇒ 00:11:50.309 Mustafa Raja: What else you want to edit? I think, we only want to do this.
147 00:11:50.920 ⇒ 00:11:52.680 Awaish Kumar: I just wanna work on this.
148 00:11:53.110 ⇒ 00:11:53.910 Mustafa Raja: Oh my god.
149 00:11:54.470 ⇒ 00:11:55.879 Awaish Kumar: Okay, okay.
150 00:11:57.260 ⇒ 00:11:59.710 Awaish Kumar: Okay, I think we are good now.
151 00:12:01.440 ⇒ 00:12:02.300 Awaish Kumar: Thank you.
152 00:12:02.570 ⇒ 00:12:03.720 Awaish Kumar: That’s all I…
153 00:12:03.720 ⇒ 00:12:05.100 Mustafa Raja: Thank you, have a good day.