In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Consolidate Excel files in one

lgl_
5 - Atom

I have +200 Excel files with exactly the same disposition with only two columns (fist column with the name of the field and second column with the value of the field).  I require to build a workflow by which from these +200 Excel files create only one Excel file keeping the first column (name of field) and with +200 columns with the value of the fields of each Excel files.  See below

 

Example.jpg

3 REPLIES 3
marcusblackhill
12 - Quasar
12 - Quasar

Hey @lgl_ !

 

You can import all doing the replacement of the filename by the "*" and after that doing one crosstab.

 

Look at the example attached.

 

Hope that help!

lgl_
5 - Atom

Safe many hours! Thanks!

marcusblackhill
12 - Quasar
12 - Quasar

Happy to help my friend!

 

Always count with the community! ðŸ™‚

Labels
Top Solution Authors