Using Multi Variable Loop action to be generate multiples files

SourceChanged procedure forces creating new file

Basically when year changes the new file is created

>> Can I also assume this will work for CSV to CSV output as well? This is csv to xl

Yes, it will
 

Interesting ! Sorting becomes critical then

The function remembers the previous value like accumulated string in memory without accumulating 

what does Result:='test';do ?

 

>>> what does Result:='test';do ?

The calculation has to return something otherwise it will fail  

To close this loop, 

Run Transformation
Get error to see only one file generated
Remember the file name is from variable <file_name>
Get Error again
Get angry , change format to xls and hope this work (get ready to complain csv is stepchild)
Get error again
Change library , go back to 016 and see file name is called {GetVariable('<file_name>')}
Run package get error again
Change library , save 016 ats in your library 
Load 016 ATS
Find in transformation the calculation field is supposed to be left hanging and not connected in output
Make Changes
Transformation works - Multiple files Output nice


Run another package using Loop function to send file 
Get error in package
Check variable names and keep headers with {} for easy detection
Run package error again
Check Loop and find forgot to check - Multiple Variables
Run package and mails are sent with attachments to relevant people