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
Solved! Go to Solution.
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
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
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.
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.
Many thanks
Shanker V
Hi @Motivator
Please find the output setting changed one, where you will be able to overwrite the output each time when your run the workflow multiple times.
Works for the second and 3rd run also.
Many thanks
Shanker V
or you can just simply select the append to existing option
HI, Thanks for that, but it is the first run that is not working, it isn't creating the excel spreadsheet?
Sorry for the delays I am working on other normal business things at the same time.
Based on the error message I see the below file name as
"Error: Output Data (19): Error opening file: C:\Users\dp36405\Output 24012023.xlsx|||C__Users_dp36405_David.xlsx"
Post .XLSX||| It should have the sheet name right. Why again the .XLSX name.
So there is something went wrong in the formula tool.
Many thanks
Shanker V