How to split excel data using a specific column using Studio

[raisonne (DEJ Raisonne)]

[supermanPunch (Arpan)]

@supermanPunch

@raisonne ,

From the Screenshot provided in my early post, It was For Each Activity that need to be used and not For Each Row in Datatable Activity.

Let us know if you were able to get it to work after you have performed the changes.

[raisonne (DEJ Raisonne)]

no error already; trying to run but seemed like it’s stuck. not generating output

[supermanPunch (Arpan)]

@raisonne

no error already; trying to run but seemed like it’s stuck. not generating output

@raisonne ,
Could you try Debugging and Check at what activity it is getting stuck ?

[raisonne (DEJ Raisonne)]

I think it’s stuck here

[raisonne (DEJ Raisonne)]

no longer stuck but getting this error.

how to delete/ ignore blank rows?

[raisonne (DEJ Raisonne)]

It’s working now. However, 2sheets are being created (same content)