1 00:00:00,510 --> 00:00:07,530 In this video, we will solve a very important problem in which we will convert columns that contain 2 00:00:07,540 --> 00:00:09,810 delimited values into us. 3 00:00:09,840 --> 00:00:12,360 Let me show you the set. 4 00:00:12,390 --> 00:00:15,220 So here I have prepared a very small data. 5 00:00:15,870 --> 00:00:17,730 So let me zoom in. 6 00:00:19,590 --> 00:00:26,160 And here you can see we have a different products belonging to different customers. 7 00:00:27,040 --> 00:00:35,320 And these are the cities you can assume these are the warehouses to which these borders are belong. 8 00:00:37,060 --> 00:00:44,170 And we need to know that how many products are available in each warehouse. 9 00:00:45,060 --> 00:00:45,420 Right. 10 00:00:46,240 --> 00:00:48,730 So how we will do this? 11 00:00:48,970 --> 00:00:51,290 Let's go to the power grid. 12 00:00:51,550 --> 00:00:55,650 So I had already imported this data into the power by. 13 00:00:57,320 --> 00:01:00,620 And here I have tracked one city, Collum. 14 00:01:01,740 --> 00:01:06,300 And if I drag one more column, that is products. 15 00:01:08,530 --> 00:01:17,230 And these are the products that are available for every warehouse, and I need to know that how many 16 00:01:17,230 --> 00:01:22,670 products are available or how many products belong to each warehouse. 17 00:01:22,690 --> 00:01:30,070 So what I can do is here you can see I can go here and I say, OK, just need to count. 18 00:01:31,520 --> 00:01:39,830 And here you can see we are getting for every warehouse there are like Islamabad, Karachi, Peshawar, 19 00:01:39,830 --> 00:01:44,490 we are getting three products and we are getting two parts. 20 00:01:45,230 --> 00:01:47,290 Let's go to the underlying data. 21 00:01:49,800 --> 00:01:50,170 And they. 22 00:01:51,510 --> 00:02:00,330 So here, if I let love, we have seen three properties out three and there are three properties, but 23 00:02:00,330 --> 00:02:05,850 if you look carefully, you will see how many partners we have. 24 00:02:06,270 --> 00:02:09,570 This is mostly keepers because this is it for. 25 00:02:10,580 --> 00:02:14,330 And then we have a computer. 26 00:02:15,260 --> 00:02:16,460 And mobile. 27 00:02:17,520 --> 00:02:24,950 The six is the chemistry there, so there are there should be six parties that belong to Lahore, right. 28 00:02:25,560 --> 00:02:32,090 And in the same way the other parties are available for the different warehouses. 29 00:02:32,790 --> 00:02:41,500 So I assume if we have like hundreds of Camarda limited powers and we want to see each and every product 30 00:02:41,520 --> 00:02:45,460 belong to each of our houses, are we want to calculous here? 31 00:02:45,810 --> 00:02:49,800 It is very difficult task to count these products manually. 32 00:02:49,980 --> 00:02:57,800 So what we can do is we need one roll per day limited value so that we can easily calculate height. 33 00:02:58,050 --> 00:03:00,960 For this, we have to click to the 200. 34 00:03:05,220 --> 00:03:13,260 And we need to select this product, go to the task form, and here you can see Spatt column. 35 00:03:15,810 --> 00:03:22,650 And we just need to click buy limited, let me show you one more thing. 36 00:03:22,960 --> 00:03:31,350 If you click on them, you can see different options like buy Delimiter, Nebraska, position, Lorqess 37 00:03:31,350 --> 00:03:32,380 and many more. 38 00:03:32,850 --> 00:03:36,440 But here we have only delimiter click. 39 00:03:37,050 --> 00:03:46,560 We need to choose comma because all the values are comma separated and then there are different options 40 00:03:46,560 --> 00:03:46,890 available. 41 00:03:46,890 --> 00:03:47,180 Right? 42 00:03:47,190 --> 00:03:55,380 If you don't have the spare semicolon, you can select custom and here you can write any separator according 43 00:03:55,380 --> 00:03:56,880 to your case. 44 00:03:57,690 --> 00:03:59,940 But for our case it is comma. 45 00:04:03,460 --> 00:04:10,090 And we need is on it and here is our advance option. 46 00:04:11,010 --> 00:04:18,780 It is surprising to find the values, common values, and then split into groups, you need to select 47 00:04:18,780 --> 00:04:20,690 this option only, right? 48 00:04:22,460 --> 00:04:30,260 So then we just need to click, OK, and here you can see we are getting these values. 49 00:04:31,250 --> 00:04:37,560 All right, so now we need to load this data closer and apply. 50 00:04:43,250 --> 00:04:51,880 And here you can see we are getting these values for lower reason, it values why it is it. 51 00:04:52,120 --> 00:04:56,810 Let's go to the director and select Lahor. 52 00:05:00,210 --> 00:05:07,420 So here you can see we are getting like the USPS people keep our looking computer. 53 00:05:08,040 --> 00:05:11,000 These are two times, right? 54 00:05:11,760 --> 00:05:15,540 And again, the USPI is also two times. 55 00:05:16,690 --> 00:05:23,360 So how we will fix this issue and we will see this issue for the other cities as well. 56 00:05:24,430 --> 00:05:32,710 So we just need to click to the report and if you will, here under values. 57 00:05:34,690 --> 00:05:41,950 So here you can see first we were getting the count and now we need to click the distinct count, the 58 00:05:41,950 --> 00:05:48,490 count distance function, and once you will click here, you will see everywhere, you know, in in 59 00:05:48,490 --> 00:05:49,270 proper order. 60 00:05:49,420 --> 00:05:53,640 The lawyers say it just takes an hour or so. 61 00:05:53,650 --> 00:05:55,810 In this way you can. 62 00:05:56,800 --> 00:05:58,000 Solve your issues. 63 00:05:58,150 --> 00:06:04,330 The only thing that you need to remember when you will perform this operation, the command element 64 00:06:04,330 --> 00:06:09,050 of values in the in the column, and then you will convert these values into roles. 65 00:06:09,580 --> 00:06:14,290 The only problem, you will get the duplicate value, right. 66 00:06:14,450 --> 00:06:17,930 So you just need to take care of the duplicate values. 67 00:06:17,950 --> 00:06:20,950 In this way, you can solve your business issues.