How can I create multiple spreadsheet with different name.
i.e One spreadsheet for Bob, second for ROB, Third for Jcob.
In an actual data I have 20 different names for name. So I need 20 different spreadsheet from one big sheet.
How can I do that?
Use Group by to get a list of names;
Chunk loop to loop through the list
inside use Rule engine for filtering records for current name;
string manipulation node to create path+name
pass path to Excel Writer
End of loop
Thanks @izaychik63. But in my case group by function eliminated some data.
Because I want data as is for different names, I can not select any aggregation.
And if I use all the column as a group by, it eliminates some data.
I don’t know why it is happening.