 So in this video you will see how we can play with the editing columns. So what is editing column? So basically we are having the query editor and inside the query editor we played with the rows we also played with the append queries and now it is time to editing the columns. So go to on powerplay desktop and here we are having this query editor. So if you haven't watched the last two videos so I would strongly recommend to watch those videos before going forward. So here we have this combined country sales table. So in this table we can see we are having a lot of columns but I just want to remove those columns those are not required. So here we can see inside the home ribbon we are having choose column and remove columns. So in the choose column we are having choose columns and go to columns. Second in the remove columns we are having remove columns, remove other columns. So what it means and how we can use it. So here just see what are not the relevant for us we just want to remove those columns. So here as we can see this modified date is not required for us and this row GUID is not required then this is not required not required. So these few columns are not required for us. So after this country as I can see these are not required to us. So what it means so how we can remove those columns. So we can select that column which is not required and we can simply remove column. So that column will be removed and if you want to remove multiple column we can select and we can click on the remove columns. So all those columns will be removed. Just do one thing roll back this. So what the mean of remove other columns. So for that we have selected this modified date. So we can remove other columns. So all the columns will be removed except this modified date column. So this is remove other columns. So here we just want to remove last few columns. So after this country we just want to remove these columns. So we can that click on remove columns. So that is removed. Next is choose column. So as we can see if we are having at the starting and we don't know where is the city column we are having more and more columns. So it is very difficult to find out only that column. So for that we can use the go to column. And here we can see we are having this list of columns. This is city. So we can select and click on ok. So it will directly jump to the city column that is good. Now what is choose column? In the choose column it will have all the list of columns and if we will select only those columns those are required. And other columns will be removed we will unselect over here. So for example let me select this due date. So it will get only this due date and other columns will be removed. So this is all about the choose columns and remove columns. So I hope you have understand about the remove columns and how we can play with the remove columns. So in the next video we will see how we can replace the existing value with the new value and how we can also format the data type of the columns. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos.