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

Dynamic Input - metadata (filename, record number in file list) as output fields

Currently if I read multiple files through Directory Tool +Dynamic Input, I will not know which final records is from which file, which can be extreme useful.

 

I also know, the files need to be the same schema (a second limitation), but the filename itself will be handy

2 Comments
DanielG
12 - Quasar

Hi,

 

When you add the dynamic input and connect the template data source you get the pop-up box with the connection link and the options listed underneath.

 

Item#4 is Output fieldname as field, which you can change to File Name Only or Full Path to get that information.

 

As it pulls each item in from the the directory it will tag each row with the filename or full path (depending on your choice).

 

That should solve your problem.

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