Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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!
Rather than a batch macro, I think an iterative macro may be a better solution for you.
Im still not 100% clear on what the data is supposed to be doing, but I think I got enough here for you to be able to alter it and make it your own.
Basically, its doing what your original image shows. It takes the unique values, transforms them with transpose and crosstab and sends them to the main output.
The items that come out of the duplicate anchor are sent to the Leftovers output to be sent into the input again. Its set to iterate up to 100 times but that can be increased if needed. If it finished before it hits 100 it will just stop early.
