We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch Macro for One file that contains duplicate columns?

kkkim
8 - Asteroid

Hi, Everyone!

 

I am looking for some help with batch macro. Wondering if attached can be made into a macro. Basically, it's one file that contains extracts of multiple tables. I need to consolidate all the tables and transpose the data into one table containing multiple values. 

 

To achieve this, I used unique tool to filter columns (since same column headers are used for all tables), and repeat transpose for each then union them... 

 

Wanted to know if there is a more efficient way of doing this.

 

Thank you!

 

Capture.PNG

10 REPLIES 10
SPetrie
13 - Pulsar

Glad its working. If you could make it as solved I would appreciate it. That way others with similar requests may be able to find it easier.

Labels
Top Solution Authors