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.

Batch Macro Pivot Table

brightonle
6 - Meteoroid

Hello, I was wondering if anyone knew how to create a batch macro to get null record values to pivot to one record. I have program data along with activity data and underneath the program would be some null records that contain additional activity data. So for example if I had one null record it would add one additional activity to the specific record. I want to create a batch macro to do this however I am not sure how to create one. I attached the input and output that I want. Thanks!

5 REPLIES 5
binuacs
21 - Polaris

@brightonle workflow attached

image.png

brightonle
6 - Meteoroid

I am still having an issue where it is giving the same name repeatedly. I am outputting the correct number of rows though. Help would be appreciated!

 

 

binuacs
21 - Polaris

@brightonle will check

brightonle
6 - Meteoroid

@binuacs Great thank you!

binuacs
21 - Polaris

@brightonle updated workflow attached

image.png

Labels
Top Solution Authors