Bifurcate the data based on Column A and Column B

Help Studio
, ,
1

Hi,
I have an excel sheet that contains some data.
I need to bifurcate the data and create a csv to upload with column D,E,F only.
And the data has to be bifurcated based on column A and column B.
If the column A and B contains same data than we need to copy data into csv with D,E,F columns.
Same like this.
I have attached the file to be used for the same.
TestingFile.xlsx (10.9 KB)
Can anyone let me know how to solve this??
Thanks in advance!!

2

@supermanPunch @Gokul001 @ushu @kirankumar.mahanthi1 @Palaniyappan @Sudharsan_Ka @Anil_G
Can you please help?

3

@Kunal_Jain

As I understand you want to group the data based on A and B columns

use a for loop activity with dt.AsEnumerable.GroupBy(function(x) x(0).ToString+x(1).ToString)

for each iteration each set of csv is created

image
image1182×692 45.2 KB

cheers

4

Hi @Anil_G
It is giving the wrong output
We need to save the value just for the column until that value is there.
Only this values need to be saved in the csv.
If it has 3 rows we need to save only 3 rows and not the whole data.
Currently it is saving the complete data from 3 columns.
Thanks!!

5

@Kunal_Jain

Are you using the loop properly?

can you show a screenshot

cheers

6

Hi @Anil_G
Yes I used the loop properly
Please have a look

7

@Kunal_Jain

Please show me the code…

Looks like you used same filename…can you show please

Cheers