Automating Text To Columns

[JamesKing]

Hi,

I have a column containing a number of values separated by comas. These need to be separated into columns, however this number can vary widely therefore is there any alternative to the text to columns tool?

Input is

And the output i'm looking for is something along these lines

Thanks in advance!

[Thableaus · Accepted solution]

Hi @JamesKing 

Here's a way of doing it

- Use Text to Columns to Split to Rows

- Use Tile Tool to group these values by your RecordID (with Unique method)

- Use Cross-Tab Tool and you'll be set.

WF attached.

Cheers,

[Jonathan-Sherman · Accepted solution]

Hi @JamesKing,

You're right you wouldn't be able to do this using text to columns if the number of columns changes. But it could be achieved by tokenising through the regex tool and cross tabbing back as seen below:

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[JamesKing]

Wow that was quick! Both solutions work perfectly, thankyou!!