Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Dynamic numner of Columns in Text to Column Tool

Highlighted
8 - Asteroid

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

Highlighted
15 - Aurora

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

 

DavidP_0-1593166941587.png

 

Labels