In this video, we will solve a very important problem in which we will convert columns that contain
delimited values into us.
Let me show you the set.
So here I have prepared a very small data.
So let me zoom in.
And here you can see we have a different products belonging to different customers.
And these are the cities you can assume these are the warehouses to which these borders are belong.
And we need to know that how many products are available in each warehouse.
Right.
So how we will do this?
Let's go to the power grid.
So I had already imported this data into the power by.
And here I have tracked one city, Collum.
And if I drag one more column, that is products.
And these are the products that are available for every warehouse, and I need to know that how many
products are available or how many products belong to each warehouse.
So what I can do is here you can see I can go here and I say, OK, just need to count.
And here you can see we are getting for every warehouse there are like Islamabad, Karachi, Peshawar,
we are getting three products and we are getting two parts.
Let's go to the underlying data.
And they.
So here, if I let love, we have seen three properties out three and there are three properties, but
if you look carefully, you will see how many partners we have.
This is mostly keepers because this is it for.
And then we have a computer.
And mobile.
The six is the chemistry there, so there are there should be six parties that belong to Lahore, right.
And in the same way the other parties are available for the different warehouses.
So I assume if we have like hundreds of Camarda limited powers and we want to see each and every product
belong to each of our houses, are we want to calculous here?
It is very difficult task to count these products manually.
So what we can do is we need one roll per day limited value so that we can easily calculate height.
For this, we have to click to the 200.
And we need to select this product, go to the task form, and here you can see Spatt column.
And we just need to click buy limited, let me show you one more thing.
If you click on them, you can see different options like buy Delimiter, Nebraska, position, Lorqess
and many more.
But here we have only delimiter click.
We need to choose comma because all the values are comma separated and then there are different options
available.
Right?
If you don't have the spare semicolon, you can select custom and here you can write any separator according
to your case.
But for our case it is comma.
And we need is on it and here is our advance option.
It is surprising to find the values, common values, and then split into groups, you need to select
this option only, right?
So then we just need to click, OK, and here you can see we are getting these values.
All right, so now we need to load this data closer and apply.
And here you can see we are getting these values for lower reason, it values why it is it.
Let's go to the director and select Lahor.
So here you can see we are getting like the USPS people keep our looking computer.
These are two times, right?
And again, the USPI is also two times.
So how we will fix this issue and we will see this issue for the other cities as well.
So we just need to click to the report and if you will, here under values.
So here you can see first we were getting the count and now we need to click the distinct count, the
count distance function, and once you will click here, you will see everywhere, you know, in in
proper order.
The lawyers say it just takes an hour or so.
In this way you can.
Solve your issues.
The only thing that you need to remember when you will perform this operation, the command element
of values in the in the column, and then you will convert these values into roles.
The only problem, you will get the duplicate value, right.
So you just need to take care of the duplicate values.
In this way, you can solve your business issues.