Hello, I have a txt file which when converted to csv looks like this: IDKEYHumidCoolNameABC110(null)AppleABC12P0OrangeXYZ13A0MangoXYZ14X0BananaABC25T0PineappleXYZf26R0Pears 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?

Split a delimited txt file to multiple xlsx.

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?

Developer Tools

Settings

Interface Tools

Accepted answers

ShankerV

@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

Split a delimited txt file to multiple xlsx.yxmd

ShankerV

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

Split a delimited txt file to multiple xlsx.yxmd

All comments

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

@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!!!!