In this video, we will learn about list.
So let's go to the power created this by clicking transformed into.
And here you can see sort of data set, so.
We can just make a copy control to control the updatable, and the name up to this table will be to
sell to.
So, for example, we have here Chenin that contain different channels here.
Can consist of one column or more than one column, but lists contain the value from the single column.
So let's go to the, uh, for example, we want to make a list, uh, for channel column.
And when for this we have to click effects like we knew.
We need to add one step.
So either you can do here or you can do with the advanced editor.
So if you click here effects.
So the previous one was sorted of.
So for the list, we have to, uh, write one ticket and the name of the column will be genuine.
That's it.
This is the list.
No, we need to make as list have many functions.
So let's apply one function, like we want to have distinct, listed, distinct items from this list.
So for this, we have to click again effects the previous variable was on one, as you know, my in
my previous belief that every time we have to use the previous the value from the previous video.
But so as we know that this is a list, the name the name of the list is custom one.
So what we have to do is we just need to use a list and list dot.
So we need distinct.
So this is a function for the list and then we need to start checking.
So here you can see the first parameter that is required for the function is a list and custom one is
a list and that's it.
We don't have any equation criteria, so we just need to close.
And here you can see we are getting a list of.
Distinct channels, so we can do we can perform some more functions, for example, let's make the list,
just delete this two and maybe we can also talk to the column.
So we have the last step was renamed column.
So we can do we can make a list of, uh, unit price.
Or we can make the list of all the quantity so far, this we just need to click and fix.
And to make a list for this column, we just need to click, we just click right wreckages and the name
of the column, so it is out of quantity.
That's it.
So here you can see this is the list of the quantity.
And as it is a list, so we can if we want to find the maximum value of the minimum value of the every
value.
So let's see what.
Because there are many functions available.
So let's play some for simple.
Either I can make a new step or either I can work within the same step because I know this whole thing
is is one list is this expression is there to name me one list.
So I have it right here.
List DOT, for example, next.
And so makes one list as a parameter.
So this list so you can close it here.
So here you can see the maximum order quantity is 12.
So if we go to rhenium column here and go to the other country, click here.
So here you can see the maximum value is the maximum or the 12 and the minimum is five.
So let's go to the custom column.
And here we can write me and you can see the minimum value is five.
And you would in this video, you can find a lot of this function.
For example, here you can see list DOT and there are many functions available here.
Right.
So let's play fun blanko here.
And we can make one list for Ssempa.
One, two, three, four.
So you can see this is a list one, two, three, four.
And in the same way, we can write for them.
We can write some cities name like a city one,
32,
33,
and here you can say one more thing, like
we can just delete it.
And here can make one more list, for example, for the channel.
So we just need to click effects.
And here it is channel.
This is one list and we need.
For example, again, the distinct
Lyster distinct.
And, uh.
Say, and if we want to apply some sorting here.
So again, it is again, we can apply list and list, not
the start thought, and let's not start again, need one list and here it is, a list.
Right.
So we have added to three list in one step.
And here you can see this in ascending order.
Right.
So in this video, you have seen how we can work with the list.
And in the next week we will see what are the usage, practical usage of list in real life.