How to store the data into multiple files based on values in a column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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