Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Text to columns, create as many columns as there are delimiters

I love this tool,  but think it would be improved by including an option to create a column per delimiting character.  This could be added in the number of columns selector box.  In the case where 1 row has more delimiters than another, null columns can be created.  Without this option you have to Regex count the delimiters, select the max and then embed the Text to columns tools in a macro and then pass the max columns as a param.  Would be nice to resolve all this in the main tool.

 

Thanks, nick

2 Comments
Asteroid

Great idea - create as many columns as the record with the most delimiters. This would be especially useful for times when the number of delimiters changes in the source data.

Meteor

@spainn i've always wanted this, too!

 

there is another workaround for this that's less complex than creating a macro (RecordID>>Text to Columns::split to rows>>Run Total>>Cross Tab::Row=RecordID;Col=RunTotal>>Dynamic Rename::First Row as Field Names). that said, it adds tools that are contextually unrelated which can distort a workflow's "readability."