The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

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

FILE FIELD PARSE 01FILE FIELD PARSE 01FILE FIELD PARSE 02FILE FIELD PARSE 02FILE FIELD PARSE 03FILE 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

2 Comments
ChrisTX
15 - Aurora

We also need to process flat files that contain multiple record types within one file.

These are ACH (payroll direct deposit) files, and the file layout is defined by the bank.

 

Looking for functionality like this:

https://help.talend.com/reader/q0GnzTBG8ARxCvmz8w5VNA/0sER3lrIPMo5QhVr8yEgIQ

 

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