Help me with my automation

#1

Hi ,
I have been trying this since 2 weeks, but not yet got the expected output.
I have a excel file (as an example) with 3 columns .One of which is named as “Name” , which consists of common names . I would like to loop through that column & get all the rows with common names & put them in a separate excel file.
Eq: Input
Name Surname Balance
raj kumar 20
raj kumar 25
raj kumar 30
ravi singh 56
ravi singh 45
parth yadav 10
suresh moti 62

Here, I need all the row details of Raj in separate excel file. Similarly, with the rest of the names. All names in separate excel file.
Output:
Name Surname Balance
raj kumar 20
raj kumar 25
raj kumar 30

Name Surname Balance
ravi singh 56
ravi singh 45

Name Surname Balance
parth yadav 10
So on…
Would appreciate any help with this. 

1 Like
About the RPA Dev Rookies category
#2
  1. Read all Values into Data table.
  2. Read Name column into List.
  3. Get Unique values from Name List.
  4. Use For each item loop. inside For each item loop
    1) Clone input data table to temp Data table.
    2) use linq query to filter input data table(DT_Input.select(“Name = ‘raj’”)) and store it in temp data table.
    3) Write temp data table values into output excel
    3) Use Clear Data table activity to clear the temp data table.

Not able to upload workflow though i created workflow.