Hi,
I have a large dataset with several data instances combined e.g.
RowID Name Country
1 X X
2 X X
3 X X
4 X X
1 X X
2 X X
3 X X
4 X X
I want to split this dataset currently read from excel into two tables, it must be dynamic as the number of rows per set can change for instance set two have 5 rows instead of 4 etc.
How do I do this? I've tried using the variable row loop and tried using the variable condition loop end. It does not work even though I try to "split" the loop each time 1 is encountered.