Dynamic numner of Columns in Text to Column Tool

[TarunDeep]

Hi,

Is there any way to dynamically change the number of columns to split the text into.

My input csv file doesn't have fixed number of columns and might change user to user. How can I not fix the number of columns.

So that workflow identifes the number of columns, to split into, dynamically.

Thanks,
Tarun

[DavidP · Accepted solution]

Here's an example of using Text-to-Columns in "split to rows" mode to split unknown number of columns and then use Crosstab to to return them to the desired format