1
00:00:00,180 --> 00:00:08,610
In this video, we will learn about Gines and transport functionality in poverty that some good example.

2
00:00:09,540 --> 00:00:12,200
So let me show you the data model.

3
00:00:13,500 --> 00:00:20,130
So here you can see we have a product category, product subcategory.

4
00:00:22,060 --> 00:00:26,980
And then we have a product, this product, right?

5
00:00:29,230 --> 00:00:40,220
So we need to first join these two tables, then we will see how we can do the task force in any language.

6
00:00:41,320 --> 00:00:43,280
So let's go to the power created.

7
00:00:43,720 --> 00:00:45,730
Just need to click transform data.

8
00:00:50,800 --> 00:00:54,050
And here we have products category.

9
00:00:54,490 --> 00:00:57,290
This is one table and this one is the second table.

10
00:00:57,310 --> 00:01:06,070
So first we need to click like a bar category and then you can go to much beauty here and click to them.

11
00:01:06,070 --> 00:01:12,700
Much curious as new, because we need to do all the transformation in a new category.

12
00:01:17,630 --> 00:01:24,680
And here we have to select the column on which we will join these two tables, the first the column

13
00:01:24,680 --> 00:01:25,400
that we need.

14
00:01:25,910 --> 00:01:27,020
This is a product key.

15
00:01:27,620 --> 00:01:29,750
And the second table is.

16
00:01:33,240 --> 00:01:40,650
Product subcategory, this one, and then we need product category as a foreign key here.

17
00:01:43,200 --> 00:01:44,070
Product category.

18
00:01:44,490 --> 00:01:49,830
Right, and here you can see a joint kind.

19
00:01:51,030 --> 00:01:57,840
It's a letter, Regina, and because we need only those categories where the product category is matched

20
00:01:57,840 --> 00:02:00,240
to the products of category division.

21
00:02:01,560 --> 00:02:10,830
And here you can choose, you know, enjoy and click, OK, so every row is a table, as you know already,

22
00:02:11,970 --> 00:02:14,520
because we are getting against every product.

23
00:02:14,930 --> 00:02:16,320
We are getting one table.

24
00:02:18,090 --> 00:02:26,970
And what we need is we are interested in the product in this product category name.

25
00:02:28,050 --> 00:02:31,100
So we need to add another column here.

26
00:02:31,830 --> 00:02:33,530
Just need to go to the click.

27
00:02:34,050 --> 00:02:36,700
We just need to click add column, custom column.

28
00:02:37,020 --> 00:02:40,380
Here we have to write one function table.

29
00:02:42,200 --> 00:02:48,710
That select column, then we need to provide one, the first parameter is the table, and here you can

30
00:02:48,710 --> 00:02:52,340
see the name of the table is the important subcategory.

31
00:02:52,610 --> 00:02:56,330
This is the column that contains the information table with every row.

32
00:02:57,080 --> 00:02:59,480
So here we have to provide them subcategory.

33
00:03:01,640 --> 00:03:09,920
This one and then which column in which we are interested, we are interested in the English product

34
00:03:09,930 --> 00:03:19,190
subcategory name, so it will be English and we need to close.

35
00:03:22,890 --> 00:03:27,030
So here you can see we are getting one error, so there is a problem with the column in.

36
00:03:29,040 --> 00:03:36,960
So we need to click here setting, so we just need to change the sun because the column name was not

37
00:03:36,960 --> 00:03:37,380
correct.

38
00:03:38,220 --> 00:03:46,800
So in this broader subcategory name, like, OK, so here you can see we are getting this table for

39
00:03:46,800 --> 00:03:56,700
every product category and below you can see there are different subcategories in every category and

40
00:03:56,700 --> 00:03:57,540
we need to.

41
00:03:59,200 --> 00:03:59,980
To hospitals.

42
00:04:00,920 --> 00:04:07,880
This column in front of every product category, so how we can do that, we just need to add one more

43
00:04:08,000 --> 00:04:08,720
column here.

44
00:04:10,880 --> 00:04:15,890
Let me, Sumit, and here we have to write.

45
00:04:17,760 --> 00:04:25,770
For example, table that transpose, so this is the function that need.

46
00:04:26,730 --> 00:04:29,200
One table and what is the table?

47
00:04:29,220 --> 00:04:37,140
It's a custom I just saw one column table cloth and the here and then we need to click.

48
00:04:37,140 --> 00:04:41,370
OK, so here you can see if you click here.

49
00:04:43,850 --> 00:04:51,650
We are getting different columns depending on the value, so we will get as many columns as we have

50
00:04:52,790 --> 00:04:57,260
values are the rules in the broader subcategory column.

51
00:05:00,500 --> 00:05:08,660
And so what we need to do now, just click here and we need all the OK

52
00:05:11,450 --> 00:05:20,650
and we don't need strong columns for the secretary, French and Spanish, we just need to delete.

53
00:05:20,930 --> 00:05:27,970
And here you can see, no, we can change the the name of the column depending on your requirements.

54
00:05:27,970 --> 00:05:31,220
So you can say this is the product category.

55
00:05:31,730 --> 00:05:38,360
And with every product category, you can see the number of subcategories are being transposed.

56
00:05:38,390 --> 00:05:44,360
So here you can see how easy it is to transpose prose into columns.

57
00:05:45,620 --> 00:05:55,280
In the next video, we will try to add list in it and some more tables and then we will try to solve

58
00:05:56,180 --> 00:05:57,970
one a business problem.