1 00:00:00,150 --> 00:00:06,870 In this video, we will learn about how we can rename columns and how we can do certain. 2 00:00:08,020 --> 00:00:15,030 So let's go to the public gallery, Ed, we just need to transform data 3 00:00:18,010 --> 00:00:19,750 and here it is, our duty. 4 00:00:19,780 --> 00:00:21,490 Ed So. 5 00:00:22,530 --> 00:00:25,050 Let's copy this table. 6 00:00:27,810 --> 00:00:31,470 And here we can rename it like said. 7 00:00:35,820 --> 00:00:40,200 And we have here forceable shipped it. 8 00:00:41,260 --> 00:00:46,080 So if I click, all right, click and read. 9 00:00:49,620 --> 00:00:50,850 Ship undiscounted. 10 00:00:52,680 --> 00:01:02,250 So here you can see power created a general discord, able to trade in columns and see type is the step 11 00:01:02,250 --> 00:01:03,330 that you can see here. 12 00:01:04,230 --> 00:01:06,940 And then this is the old column and this is a new column. 13 00:01:06,960 --> 00:01:10,320 So let's try to write this Corbi our on. 14 00:01:11,770 --> 00:01:15,370 We need to rename authority ordered undiscounted. 15 00:01:17,080 --> 00:01:20,530 So let's go to the audience, Ed. 16 00:01:21,490 --> 00:01:32,300 So this is the last step we need to copy this variable and we need to put a comma, so name ordered 17 00:01:32,380 --> 00:01:32,680 it 18 00:01:35,500 --> 00:01:38,440 for the function will be a table table. 19 00:01:39,100 --> 00:01:40,090 Dr. Renin. 20 00:01:43,430 --> 00:01:50,460 Written in columns, and the first perimetral will be the name of the table. 21 00:01:51,030 --> 00:01:55,040 So what is the name of the cable is really my desk or column. 22 00:01:55,080 --> 00:02:01,560 We just need to copy and paste and then you can see it in the Intellisense. 23 00:02:01,980 --> 00:02:06,420 The first parameter is the table and the second parameter it takes list. 24 00:02:08,000 --> 00:02:18,440 So we need go right here, coma and one packet, and here we have to write, what's the name of the 25 00:02:18,440 --> 00:02:20,590 old column? 26 00:02:21,350 --> 00:02:29,120 This is our the date and the new name will be 27 00:02:32,630 --> 00:02:34,170 our underscore that. 28 00:02:34,940 --> 00:02:35,440 That's it. 29 00:02:36,200 --> 00:02:41,870 And now we have to use this new name in the output here. 30 00:02:47,140 --> 00:02:47,660 That's it. 31 00:02:48,220 --> 00:02:52,550 And here you can see we have no syntax error have been detected. 32 00:02:54,370 --> 00:02:55,570 So if I click done. 33 00:02:57,990 --> 00:03:05,670 You have to hear order underscored that has been this column's name has been changed from order to order 34 00:03:05,670 --> 00:03:06,440 and this date. 35 00:03:06,600 --> 00:03:08,790 So see what we are doing. 36 00:03:09,610 --> 00:03:11,310 We are here. 37 00:03:11,310 --> 00:03:16,140 We have renamed shipped it in the second step we have done. 38 00:03:18,050 --> 00:03:26,690 We have renamed order to order and escort it, so we are performing the same function whereby the same 39 00:03:26,690 --> 00:03:34,160 function we are just doing renaming and if we're doing performing the same operation, then we then 40 00:03:34,160 --> 00:03:37,900 we don't need to to add multiple steps. 41 00:03:38,210 --> 00:03:44,630 So instead of going in multiple steps, like if we have 10 columns and I need to change the name of 42 00:03:44,630 --> 00:03:49,050 the 10 column, then I don't need to write 10 steps here. 43 00:03:49,790 --> 00:03:59,150 So what we can do is we just need to click growth and here we have to write. 44 00:04:00,790 --> 00:04:05,110 Comma, and then the second list it is. 45 00:04:09,470 --> 00:04:09,770 It. 46 00:04:12,890 --> 00:04:16,960 So remember, one thing is a case sensitive you so Comac 47 00:04:19,640 --> 00:04:26,470 order on this court date and then there is another column. 48 00:04:27,650 --> 00:04:29,780 So we need to create one more list. 49 00:04:31,440 --> 00:04:35,400 So this is like order number, the first one here. 50 00:04:39,360 --> 00:04:42,770 No, no, so we will use. 51 00:04:47,530 --> 00:04:52,090 Order number and the new name will be 52 00:04:55,390 --> 00:05:00,690 harder unrest or no, that's it. 53 00:05:03,780 --> 00:05:07,950 So we need to click, enter. 54 00:05:11,210 --> 00:05:17,110 And here you can see order to score, no order to score, that needs to be changed. 55 00:05:17,480 --> 00:05:22,270 So we have and we have done all this and are changing in one step. 56 00:05:23,690 --> 00:05:25,310 And remember one thing. 57 00:05:26,750 --> 00:05:35,810 A city was renamed Column One List, so what we are providing here, we are providing this is one, 58 00:05:35,810 --> 00:05:42,470 the second list and the third list and these all three lists are wrapped. 59 00:05:43,680 --> 00:05:47,500 And in the single list, so it is a list of lists. 60 00:05:48,870 --> 00:05:56,520 So this is how we can rename different columns within one step and multiple steps. 61 00:05:57,840 --> 00:06:00,130 So in the same way, we will do something. 62 00:06:00,720 --> 00:06:08,160 So let's go to let's find some column like a delivery written index. 63 00:06:10,590 --> 00:06:11,730 So if you click. 64 00:06:14,550 --> 00:06:24,060 Maybe we can click here and start ascending so the poverty Ed has generated and called for the sorting 65 00:06:24,330 --> 00:06:25,920 and what's the name of the function? 66 00:06:25,950 --> 00:06:35,920 This is tabletop salt and it takes the name of the column that contains the result from the previous 67 00:06:35,940 --> 00:06:36,240 tip. 68 00:06:37,830 --> 00:06:40,720 And this is the name of the column. 69 00:06:40,920 --> 00:06:44,790 And here are the dot ascending. 70 00:06:45,520 --> 00:06:45,830 Right. 71 00:06:46,620 --> 00:06:52,000 So if we want to do like order quantity in descending. 72 00:06:52,920 --> 00:06:54,540 So what we have to do is. 73 00:06:57,660 --> 00:07:01,380 We just need to anti-Obama. 74 00:07:04,170 --> 00:07:12,000 And just Justin just need to use the name or whatever to the name. 75 00:07:14,970 --> 00:07:16,860 Just a minute, we just need to. 76 00:07:22,600 --> 00:07:23,620 One more ticket. 77 00:07:26,090 --> 00:07:30,290 So this is the only chick. 78 00:07:35,350 --> 00:07:36,670 Order quantity. 79 00:07:38,800 --> 00:07:45,160 So this is the name, right, order quantity, and we have to right here. 80 00:07:46,700 --> 00:07:48,860 Underscore Colma. 81 00:07:54,890 --> 00:08:03,140 Order, quantity, comma, pardon? 82 00:08:03,290 --> 00:08:08,120 This is the function of the dot descending, as you can see. 83 00:08:11,080 --> 00:08:15,640 That's it, so we need to press enter. 84 00:08:18,860 --> 00:08:29,060 And here you can see the first colonists delivery region index is in ascending order and the order it 85 00:08:29,060 --> 00:08:34,600 is in the descending order, C, the the arrow and the same arrows offered. 86 00:08:34,610 --> 00:08:36,540 So it's ascending and descending. 87 00:08:37,760 --> 00:08:44,300 And if we look at the advanced ed, so here you can see. 88 00:08:46,470 --> 00:08:52,280 This is the newly created tape, the name is Sotiropoulos, so let's do one more thing. 89 00:08:53,370 --> 00:09:02,760 If I if I try to use if I try to rename this column, rename the school column, then again I have to 90 00:09:02,760 --> 00:09:06,210 use rename a column here as well. 91 00:09:06,570 --> 00:09:14,910 And if I use this variable in many places, then in the advanced editor, I have to do this modification 92 00:09:14,910 --> 00:09:19,390 as many cases as we have used to rename column. 93 00:09:20,310 --> 00:09:25,200 So what we can do is not like if I. 94 00:09:25,440 --> 00:09:35,100 So we have do we have to rename this this variable and it should automatically rename everywhere. 95 00:09:37,430 --> 00:09:48,290 So just click cancel if you change the name here in the applied steps, so like, right, click rename 96 00:09:49,700 --> 00:09:55,670 and we can rename rename call Facenda. 97 00:09:56,030 --> 00:09:58,280 This is the name of the variable. 98 00:09:59,690 --> 00:10:03,170 OK, and now let's have a look in the advanced ed. 99 00:10:05,200 --> 00:10:09,220 So here you can see rain call and it is automatically. 100 00:10:11,060 --> 00:10:14,270 Renamed Here in the Steps. 101 00:10:15,630 --> 00:10:22,830 So whenever you use whenever you rename anything here in the in the graphical user interface, it automatically 102 00:10:23,160 --> 00:10:25,180 applied in all the places. 103 00:10:25,980 --> 00:10:32,880 So in this area, we have learned two functions of the table, like one is the reading column and the 104 00:10:32,880 --> 00:10:34,750 other one is the tabletop sort.