community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Ability to use 'Field Settings from File' outside of the Input tool

So in my line of business we get .txt or .dat files that we consider are dump files with customer data in it. The prior record keeper would then provide their layout that determines where certain participant data lives within those files. So currently we have multiple INPUT DATA tools that all parse for different records using the 'Read it as fixed width text file' radio button in the Resolve File Type window and then 'Use Field Settings from File' that we've created from .flat files.

 

CURRENTWORKFLOW.JPG

FAKE01PARSE.JPGFILE FIELD PARSE 01FAKE02PARSE.JPGFILE FIELD PARSE 02FAKE03PARSE.JPGFILE FIELD PARSE 03

As you can see above each 'RECORD' has a different field setting within the same file. This is fine when it's a few records but we have some prior record keepers that have 15-40 different records within the same dump file. Because of this, our workflows are being bogged down by having to continually open the same file over and over and apply a different file field setting. So I am suggesting we pull Field settings into a separate tool, sort of like a text to column tool but instead of parsing by a specific delimiter it parses by a specific .flat file that contains Field Settings. so instead of our workflow looking like it does above, it would look something like this:

IDEA.JPG