Two Loops problem


I have problem with this workflow could someone help me?


My goal is to divide database (spliting it to some parts) then having logins of worker in different table using it as a file name when writing it as a new file in specific place. I got to the point that it is written in 5 parts according to logins but problem is that it only use the same and the same part of database. I have been trying to fix it but without success.


What I have done wrong? 

Hi 89trunks, 

Your workflow works this way since you're using a loop inside another loop, so your files are overwritten several times. 

I suggest that you have a connection between two tables, in this case I would recommend to join two table beforehand and then use the Group Loop to loop over specific categories of records. 

Please find attached a sample workflow.