Multiple csv output files with constant few rows in each file

Hi,

I have a workflow where I am creating multiple csv output files. All the csv files are generated fine.

However, I need to have a few rows of data as constant on each of these output files. Attached sample format for reference.

Can someone please help?

Thanks

Keyur

Sample.xlsx

Output

Accepted answers

JoshuaGostick

Hi @keyur_ubs,

I understand. I've created a workflow that should hopefully solve your solution. In brief, it uses the list of letters from Input 1 to create multiple output files and then uses sorting logic to ensure that it is in the right format.

You will need to change the Output tool at the end so that it is pointing to one of your folders instead of my one.

Let me know if you have any questions.

Multiple CSV Output Files.PNG

Thanks,

Josh

Multiple CSV Output Files.yxmd

All comments

Goppi

It would be good if you could share the workflow with a mockup of the two input files. Otherwise people make an effort and it might not work with the way you designed your workflow.

Goppi

JoshuaGostick

Hi @keyur_ubs,

To get the same format of your outputs, you could use the Union tool and select Auto Config by Position. This will allow the rows from Input 2 to be stacked on top of Input 1. Make sure that the Output Order is correct so that Input 2 is at the top

The Union tool should be configured something like this.

Union on Position.PNG

Would this be a good start for helping you with your issue? Please let me know if you have any further questions.

Thanks,

Josh

keyur_ubs

Hi Josh,

I tried that, but that would stake the rows from Input 2 on top of Input 1. But for output, I need to split data from Input 1 into multiple output file by field 1 of Input 1 and each of these output csv file should have those rows from Input 2 staked on top of the data.

Thanks

Keyur

keyur_ubs

its a simple workflow. I am using two inputs as shown in sample excel. Data of Input 1 is split into multiple output files depending on field 1.

All I need is a way to stake rows from Input 2 on top of each of the dynamically generated csv file.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703