Split a delimited txt file to multiple xlsx.

[maaz]

Hello,

I have a txt file which when converted to csv looks like this:

ID	KEY	Humid	Cool	Name
ABC1	1	0	(null)	Apple
ABC1	2	P	0	Orange
XYZ1	3	A	0	Mango
XYZ1	4	X	0	Banana
ABC2	5	T	0	Pineapple
XYZf2	6	R	0	Pears

I want to split the above table on basis of different ID into multiple different xlsx file as output, so we have 1 workbook for each unique ID field.

Any idea how I can implement the same?

[ShankerV]

Hi @maaz 

You can achieve with the help of Output tool.

Many thanks

Shanker V

[ShankerV]

Hi @maaz 

The below setting in the output tool helps to achieve your expected output.

Many thanks

Shanker V

[maaz]

Thanks @ShankerV for your reply.

I want the output in different workbooks and not worksheets.

Also the number of unique ID can be updated in the future so I can't use the filter tool in this case.

[ShankerV]

Hi @maaz 

Sure, that's possible in different files also.

[ShankerV · Accepted solution]

@maaz 

To save in different files.

Output:

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

[ShankerV · Accepted solution]

Hi @maaz 

Yes, the workflow will be more dynamic without filter so it can work if any more unique are added in future.

Note: 

Please change the highlighted path based on your destination folder to save.

Many thanks

Shanker V

[maaz]

Works like a charm.

Thanks @ShankerV