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!
Can it be made into a macro, yes. Im not entirely sure I understand they why part of what you are doing, but the steps can be made into a macro. Are you able to share this portion of your workflow with some sample data to look at?
Can you also attach the workflow so I can see how you are doing your transpose and cross tab setups.
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.
Thank you so much for this! This is amazing!!! I will definitely play around with this and get back to you with any questions if I have any!
Thank you!!!
Unfortunately, the file is not opening for me. Can you attach them in yxmd format? Thanks so much!!!!
Thank you ever so much! I got this done!!!