Optimisation

Hello,

I have a little problem about the optimisation of a workflow.


how to replace the process of making a union between several files by loading alteryx file by file?

 isn't there a method that can replace manually loading files? 

knowing that the proud are repatriated to 4 folders and each folder contains 4 files.

 so in all I have 16 files to load and then make the union between them

 since they have the same structure.


I tried with DIR to access the directory and then with dynamic input but it didn't work,

 maybe I don't know how to use these two tools


Could you help me please ?

Accepted answers

StephV

Merci pour ta question @ineselfehem ! et pour vos réponses @Ladarthure et @carlosteixeira !

Si ces réponses t'ont aidé, n'hésite pas à "Accepter comme solution", elles aideront surement d'autres utilisateurs.

All comments

carlosteixeira

Hi @ineselfehem.

You can read all files at once, as long as they have the same structure.

Use the input data tool and in the file name use the coring character in the file name, like this:

I hope this help you

Ladarthure

hi @ineselfehem,

multiple possibilities with a problem like yours.

If you have files in one directory, you can use as @carlosteixeira said an input tool with a wildcar (*.extension), but it needs to have the exact same format.

On the other hand if you have files which may change for the format, you can use a directory tool and then a batch macro which will not be as sensitive on the format and allows you to read multiple files without the same format, basicaly it's multiple input tools followed by an union. You can read more about this in this topic, if you need any help, feel free to ask!

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Files-with-Different-Field/ta-p/13370

StephV

Merci pour ta question @ineselfehem ! et pour vos réponses @Ladarthure et @carlosteixeira !

Si ces réponses t'ont aidé, n'hésite pas à "Accepter comme solution", elles aideront surement d'autres utilisateurs.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703