Hi, I have been looking through the current articles, and found a few that seems to show options, but I can't find anything that is clear enough for me. I have a set of Data that includes a column showing sets of names. Column1 David David Jane Jane Jane Fred Fred It then has further data, for each row, So I would like to produce a separate Excel file for David, Jane and Fred with the rows associated with that name? Please can someone help? Thanks

A little help with multiple Excel output files, based on 1 column of data.

Hi, I have been looking through the current articles, and found a few that seems to show options, but I can't find anything that is clear enough for me.

I have a set of Data that includes a column showing sets of names.

Column1

David

Jane

Fred

It then has further data, for each row, So I would like to produce a separate Excel file for David, Jane and Fred with the rows associated with that name?

Please can someone help?

Thanks

Workflow

Developer

Output

Help

Accepted answers

ShankerV

Hi @Motivator

The below step helps to achieve your output in different files.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

A little help with multiple Excel output files, based on 1 column of data..yxmd

Motivator

Sorry, just seen it, on the output file I didn't have change the entire file path?

All comments

ShankerV

Hi @Motivator

The below step helps to achieve your output in different files.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

A little help with multiple Excel output files, based on 1 column of data..yxmd

ShankerV

Hi @Motivator

Expected output:

Input was:

Note: If you have 10 different names, 0r 100, it will create 10/100 separate xlsx files containing their data only.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

Motivator

Hi, That's gets me a lot further, thanks. But it fails at the last step with error opening the excel file

"Error: Output Data (19): Error opening file: C:\Users\dp36405\Output 24012023.xlsx|||C__Users_dp36405_David.xlsx"

Do I need to create each name file ion the folder first?

Thanks for you help.

ShankerV

Hi @Motivator

The file named David, Jane etc are created in the first run itself.

Then for the second run, we need to delete the previously created files or change the path to new folder and run the output with the same setting in output tool.