output the data in two different files as .xslx or .csv

Venkatesh23

Hello guys,

I have data where it consists of companies details. Where it has 2 company data in a single file. But, I need to separate files outputs as 2 different companies (whether the output file can be .xlsx or .csv).

I was successful when I tried to output .csv.

But the problem was not able to add the file output name in the top of the output file then the following data. As shown in the below Image.

Image refers output file of comCode=1(OutputFile1)

If possible can share the ideas or sample workflow.

I have attached the sample file of Input data and required output file 1&2.

The output can be .xlsx or .csv format. whichever is possible.

Thanks in Advance.

Venkatesh

InputData.xlsx

OutputFile1.xlsx

OutputFile2.xlsx

RolandSchubert

Hi @Venkatesh23 ,

what about using the reporting tools? Create the tables using the "group by" option, add the report header to the tables and write it to Excel files using the Render tool. Find attached a sample workflow. Hope this is helpful.

Best regards

Roland 

FileOutput.yxmd