Help with for each data row loop

Help Studio
, ,
1

hi all,

i have a problem with a test i am trying to run. i am running a for each data row loop inside another each data row loop.

what i have is a tale called dt_source and then i need to extract the unique values for the column CP_SERVICE - consider it a reporting group.

then i need to loop through the source table with each unique CP_SERVICE that will group the survives (eg all rows where the service of cp1, cp2, cpe3 etc) together and create a text file that i will use for an email.

i can see that all the unique cp services are being created
Also i can see that it processed the details for cp1 correctly - (i know in the example that i have here that it repeats the process afew times but i am ok with that for now)
but it does not process anything for cp2 or cp3, or write anything for them to the text file

image
image327×655 28.7 KB

if i change cp1 to cp4 the the files for cp2 will be processed instead

any help to get the file working for cp2 and cp3 would be greatly appreciated

workflow is attached and source file is attached

thanks,
Source.xlsx (12.0 KB)

Main.xaml (19.8 KB)

2

DUPLICATE OF