Copy the values from source file to template file

[Lakshmikanth_2021]

I have two files, Input, and Output. I need to copy the values from Input to Output without changing the Output format. 

[AngelosPachis · Accepted solution]

Hi @Lakshmikanth_2021 ,

This workflow might help you towards the right direction. Essentially because the sequence that the rows should appear in your output ( in input you have A-B-C-.. etc. but in output you have C-D-E-... etc.) I have created a duplicate output file (called output_starter) that I use as a template.

Then to that template output file you assign a record id to use it so you sort your input rows accordingly. Then from your input you split to the different tables you want to write, bring in the record id from the output template and then sort it accordingly before writing to a specified range. The highlighted fields are critical to make this work as it should.

This can be made more dynamic and probably we can also figure out a way so you don't manually have to go in and specify the range manually for each table. What's your use case? Will that suffice?

Thanks,

Angelos