Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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