In this video, we will learn about how we can rename columns and how we can do certain.
So let's go to the public gallery, Ed, we just need to transform data
and here it is, our duty.
Ed So.
Let's copy this table.
And here we can rename it like said.
And we have here forceable shipped it.
So if I click, all right, click and read.
Ship undiscounted.
So here you can see power created a general discord, able to trade in columns and see type is the step
that you can see here.
And then this is the old column and this is a new column.
So let's try to write this Corbi our on.
We need to rename authority ordered undiscounted.
So let's go to the audience, Ed.
So this is the last step we need to copy this variable and we need to put a comma, so name ordered
it
for the function will be a table table.
Dr. Renin.
Written in columns, and the first perimetral will be the name of the table.
So what is the name of the cable is really my desk or column.
We just need to copy and paste and then you can see it in the Intellisense.
The first parameter is the table and the second parameter it takes list.
So we need go right here, coma and one packet, and here we have to write, what's the name of the
old column?
This is our the date and the new name will be
our underscore that.
That's it.
And now we have to use this new name in the output here.
That's it.
And here you can see we have no syntax error have been detected.
So if I click done.
You have to hear order underscored that has been this column's name has been changed from order to order
and this date.
So see what we are doing.
We are here.
We have renamed shipped it in the second step we have done.
We have renamed order to order and escort it, so we are performing the same function whereby the same
function we are just doing renaming and if we're doing performing the same operation, then we then
we don't need to to add multiple steps.
So instead of going in multiple steps, like if we have 10 columns and I need to change the name of
the 10 column, then I don't need to write 10 steps here.
So what we can do is we just need to click growth and here we have to write.
Comma, and then the second list it is.
It.
So remember, one thing is a case sensitive you so Comac
order on this court date and then there is another column.
So we need to create one more list.
So this is like order number, the first one here.
No, no, so we will use.
Order number and the new name will be
harder unrest or no, that's it.
So we need to click, enter.
And here you can see order to score, no order to score, that needs to be changed.
So we have and we have done all this and are changing in one step.
And remember one thing.
A city was renamed Column One List, so what we are providing here, we are providing this is one,
the second list and the third list and these all three lists are wrapped.
And in the single list, so it is a list of lists.
So this is how we can rename different columns within one step and multiple steps.
So in the same way, we will do something.
So let's go to let's find some column like a delivery written index.
So if you click.
Maybe we can click here and start ascending so the poverty Ed has generated and called for the sorting
and what's the name of the function?
This is tabletop salt and it takes the name of the column that contains the result from the previous
tip.
And this is the name of the column.
And here are the dot ascending.
Right.
So if we want to do like order quantity in descending.
So what we have to do is.
We just need to anti-Obama.
And just Justin just need to use the name or whatever to the name.
Just a minute, we just need to.
One more ticket.
So this is the only chick.
Order quantity.
So this is the name, right, order quantity, and we have to right here.
Underscore Colma.
Order, quantity, comma, pardon?
This is the function of the dot descending, as you can see.
That's it, so we need to press enter.
And here you can see the first colonists delivery region index is in ascending order and the order it
is in the descending order, C, the the arrow and the same arrows offered.
So it's ascending and descending.
And if we look at the advanced ed, so here you can see.
This is the newly created tape, the name is Sotiropoulos, so let's do one more thing.
If I if I try to use if I try to rename this column, rename the school column, then again I have to
use rename a column here as well.
And if I use this variable in many places, then in the advanced editor, I have to do this modification
as many cases as we have used to rename column.
So what we can do is not like if I.
So we have do we have to rename this this variable and it should automatically rename everywhere.
So just click cancel if you change the name here in the applied steps, so like, right, click rename
and we can rename rename call Facenda.
This is the name of the variable.
OK, and now let's have a look in the advanced ed.
So here you can see rain call and it is automatically.
Renamed Here in the Steps.
So whenever you use whenever you rename anything here in the in the graphical user interface, it automatically
applied in all the places.
So in this area, we have learned two functions of the table, like one is the reading column and the
other one is the tabletop sort.