How to store the data into multiple files based on values in a column

Question

Hello All,

I need your's help to complete this workflow. Since I have 3 different values in my column name and I want to store the data into 3 different output files based on the values in the column (Name).

Eg:

Name A should be stored as A.xlsx (it has 2 rows)

Name B should be stored as B.xlsx ( it has 1 row)

Name C should be stored as C.xlsx ( it has 1 row)

Note: Values in the column Name may be changed in the future like (C, D, E, and so on). I want to do this dynamically.

Please let me know is there is any option to do this.

AngelosPachis · Answer

Hi @Nethaji_5 ,

I have used a formula tool to create a Filepath of where I want the excel sheets to be stored.

That Filepath should include the Name column before the ".xlsx" and I have also used the same to rename the sheets in each Excel file.

Then in your output tool, you should make the following selections

Let me know if that worked for you

example.yxzp

atcodedog05 · Answer

Hi @Nethaji_5

Here is a workflow:

Folder before run:

Folder after run:

Workflow:

Output Tool config:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Write.yxmd

atcodedog05 · Answer

Hi @Nethaji_5 ,

You use this option in output tool to split files by column.

Blue highlighted is the column selected used for split.

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind😀👍