I need to take a spreadsheet that organizes data by row format and have it create a single spreadsheet from one field, the work order, and all the associated fields and append into column b of a spreadsheet. Then to the next row to column, and next row to column and so forth until the process is finished. It would be creating unique xls files based on the workorder number.
I have included the source file from which the row data should be placed into column b during the append process.
Sorry I don’t understand your sample file? NOTE: If you want add more files you have to use a ZIP archive.
I guess what you want and made a new example. To do this you need a second step.
The first steps groups the data with the help of the
based on the work order. A bit tricky is to put each group row from the READ side to one specific column on the WRITE side. For this you need for each column one
to decide what row is the current group row. To count the group row you need an additional
with activated GroupBy option.
The second step is just the same as the first example. Read the CSV file where created in the first step and create the unique CSV files based on the work order.
Attachment group_and_split_excel_data.zip not found
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.