Split source data in two files

[RodrigoOlmedo]

Hello

I need to separate this file in diferent files, every new table starts with "1" and detail of those tables starts with "2":

Thank you in advance

[ggruccio · Accepted solution]

Hi @RodrigoOlmedo,

This logic should work for you.  Basically I take the table name and append to each of the rows below it. 

Then use that as a field to split on file save in the output tool.

This output assumes I'm splitting the files and saving them in c:temp, but you can change the directory.

[RodrigoOlmedo]

Thank you very much !!! it works...