Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Parse with "TEXT TO COLUMNS" tool by FIELD LENGTH (not just a delimiter)

SOOOOoooooo many times it'd be great to just dictate the character length/count (fixed width) for the parse (just like you can in excel), instead of being constrained by a delimiter or being obligated to go create (potentially complex) REGEX.  Ideally you could go into the column and insert the <break> (multiple times if needed) after the given character where you'd like the parse to occur.  Anything past the last <break> would all be included in the final parse section/field. 

You could also do it a little less visual and just identify/type the character count you want for each column.  If you really want to enhance this idea, you could also include the ability to name the fields and prescribe the data type.  Those would just be gravy on the meat of the idea however, which is, provide the ability to parse by fixed length fields.

 

 

Watermark_0-1663019366956.png

 

2 Comments
analytixstudio
5 - Atom

This is such an obviuos opportunity to increse the time that Alteryx can save.  

 

I would go one step further and include a button that if pushed would provide a suggested parsing pattern based on the first X records in the data set.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes