OK so another important feature here is creating an emerging column.
So when working with the data you might find the need of splitting the values in a column or merging
them so you can do this simply in Gladiator's Suppose for example will take this under the column.
Now suppose you want to split them split the day part in one column and that time part in and add another
column.
So to do this we have this option here it split columns.
So when you click on the columns you it it will ask you to split column either by delimiter or by a
number of characters.
You have any text and you can simply just down the number of characters from by which you have to split
the columns you can do that or if you want to split the column by delimiter you can do that.
So in our case we will use by delimiter.
So when you click on that this window will pop up.
So now as you can see between hardit and our time there is our space.
So it will ask us to select or enter delimiter with a click on space.
So now it will ask us to split and we can click on the left most delimiter and simply click on OK.
So now as you can see the columns are not into two columns or the red one artery to our bed is in the
other that's in the new column and our time is in you column.
So now you we can pretty easily read my columns as well.
So just click double click on the header and rename it as order did and rename this one test order.
PAM.
So now we have two different columns.
Just like it is important sometimes to split the columns.
It is also sometimes it needed to merge the columns.
So to do that what we have to do is select both the columns which we have to march up with these two
columns only we have to march orderly and order time.
So what we could do is just select both of them with the help of shift.
Now both of them are selected.
Click on transform and then click here.
You can see the option merge columns and then you click on this.
It will again ask you what separator do you want to use and what will you have to keep the name on the
new column to separate separate.
You can keep us updated as spears and we will just simply name it this order did just one color.
When you click ok just like this order did and I'm the I didn't call the one thing you will notice this
as being all this operation.
Or diapers changed here it's changed to ABC which is text format.
But this is a date format so you know does anything like this will lead to us doing it again and do
it in time.
And when you do that this will again change into that date and time format.
So this way you can split and merge columns and not a feature here which I want to do is to use in.
But in this particular column all you want to do is take out just the days of the month to post in the
first or the 7th of May.
So you will not take out this what you said in this one 45.
And when did you just need the device to do that.
They simply click on the column and here you will see the option of the transform you would see the
option of did just click on that and click on the day and then click on this particular day so that
is it and it will explain the company from that and then do so when you click on this it will just give
you that.
But on the day of from those days.
So one important thing that I want to do is always make a duplicate of your column and then work on
it.
So right now what I have done is I haven't made any duplicate.
So it does all work done on those on my previous column.
So I do my step.
Now first of all they are duplicate by right clicking on it.
So this is my duplicate.
I'll now vote on this duplicate and it might be and now the I have the de-value and now is simply the
name of this order the.
So this was all the way you can simply split or mark the columns just like these and I'll see you in
the next to do real.
Thank you.