How to split excel data using a specific column using Studio

Help Studio
, ,
3

Hi @raisonne ,

Could you Check with the below Steps :

  1. Create and Initialise a Dictionary variable in the below way using an Assign Activity :
TeamDict = new Dictionary(Of String,Datatable)
  1. Get the Team Set as Groups, convert to Datatable and add to Dictionary using an Assign Activity like below
TeamDict = DT.AsEnumerable.GroupBy(Function(x)x("TEAM").ToString).ToDictionary(Function(x)x.First.Item("TEAM").ToString,Function(y)y.CopyToDataTable)
  1. Now, We can loop through the Dictionary TeamDict and Write the Data to separate Excel Files like shown below :
    image

Let us know if you are not able to implement this or facing issues.

2 Likes