Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Flat File Layout for multiple .txt file

wbroughton7
5 - Atom

Does anyone know if there's a way to copy/paste, the "Flat File Layout" settings, onto multiple .txt files with the same fields?

 

I find it somewhat tedious and time-consuming to update the "Flat File Layout" settings, every time I have to insert a text file to read as a flat file.

 

Any helpful suggestions would be great!!

2 REPLIES 2
binuacs
20 - Arcturus

@wbroughton7 If you want to read all the text files with the same schema then you can use the dynamic input tool, once you setup the positions it will apply the same setting to the next file and parse according to the field length

KGT
11 - Bolide

There is an option at the bottom of that Flat file settings window to use field settings from file. You will need to figure out how to save the settings as a file, but once you have, then just apply that file to each.

 

If that is still too much to configure, then a batch macro or dynamic input is going to be best.

Labels