Need to write in different sheet based on industry type, format type.csv

[Manju_Reddy_Kanughula]

[fernando_zuluaga]

Hey

Can you be more explicit, any expected output?

Regards

[Anil_G]

@Manju_Reddy_Kanughula

First read the data into dataatble…

Then newdt = dt.Defaultview.ToTable(True,{"Industry type"})

This will give you all unique industries in a newdt

Now loop through newdt and then inside loop use filter datatable to filter the main datatable dt with each industry type…

Using currentrow(0).Tostring

So gor each iteration you will have one industry type filtered. in the loop use the filtereddt and write csv activity

Cheers

[Manju_Reddy_Kanughula]

as per attached image, the csv file having different industry type. I need to save them in their individual sheets.

[Yoichi]

Hi,

Hope the following sample helps you.

dict =dt.AsEnumerable.GroupBy(Function(r) r("Industry").ToString).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable)

Sample20230120-5L.zip (3.2 KB)

Please replace data.csv with your input csv.

Regards,