In this video, we will learn about Gines and transport functionality in poverty that some good example.
So let me show you the data model.
So here you can see we have a product category, product subcategory.
And then we have a product, this product, right?
So we need to first join these two tables, then we will see how we can do the task force in any language.
So let's go to the power created.
Just need to click transform data.
And here we have products category.
This is one table and this one is the second table.
So first we need to click like a bar category and then you can go to much beauty here and click to them.
Much curious as new, because we need to do all the transformation in a new category.
And here we have to select the column on which we will join these two tables, the first the column
that we need.
This is a product key.
And the second table is.
Product subcategory, this one, and then we need product category as a foreign key here.
Product category.
Right, and here you can see a joint kind.
It's a letter, Regina, and because we need only those categories where the product category is matched
to the products of category division.
And here you can choose, you know, enjoy and click, OK, so every row is a table, as you know already,
because we are getting against every product.
We are getting one table.
And what we need is we are interested in the product in this product category name.
So we need to add another column here.
Just need to go to the click.
We just need to click add column, custom column.
Here we have to write one function table.
That select column, then we need to provide one, the first parameter is the table, and here you can
see the name of the table is the important subcategory.
This is the column that contains the information table with every row.
So here we have to provide them subcategory.
This one and then which column in which we are interested, we are interested in the English product
subcategory name, so it will be English and we need to close.
So here you can see we are getting one error, so there is a problem with the column in.
So we need to click here setting, so we just need to change the sun because the column name was not
correct.
So in this broader subcategory name, like, OK, so here you can see we are getting this table for
every product category and below you can see there are different subcategories in every category and
we need to.
To hospitals.
This column in front of every product category, so how we can do that, we just need to add one more
column here.
Let me, Sumit, and here we have to write.
For example, table that transpose, so this is the function that need.
One table and what is the table?
It's a custom I just saw one column table cloth and the here and then we need to click.
OK, so here you can see if you click here.
We are getting different columns depending on the value, so we will get as many columns as we have
values are the rules in the broader subcategory column.
And so what we need to do now, just click here and we need all the OK
and we don't need strong columns for the secretary, French and Spanish, we just need to delete.
And here you can see, no, we can change the the name of the column depending on your requirements.
So you can say this is the product category.
And with every product category, you can see the number of subcategories are being transposed.
So here you can see how easy it is to transpose prose into columns.
In the next video, we will try to add list in it and some more tables and then we will try to solve
one a business problem.