Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

How to append results of Output back to original Input Data?

CoreyS
8 - Asteroid

Hello my fellow Alteryx Community,

 

Today I ran into some challenges with re-joining the results of my macro output back to the original input data. For that reason, I need your help!

 

Started with this...

original datasetoriginal dataset

 

 

 

 

 

 

 

 

So I created this...

Alteryx_Macro.png

 

 

 

 

 

 

To get 'high-level' output like this...

Alteryx_Macro_Output.png

 

 

 

 

 

 

 

My Challenge...

--> Re-applying the 'Persona' results (as depicted in the image above) back to the original dataset with all their respective attributes. 

 

Example: Instead of showing a table with 'Persona-1' with a single record showing the total count of 'PatientID', I'm looking to show all 485 records with their respective 'Persona' category appended as a new column. 

 

Thanks for your support in advance!

 

Respectfully,

Corey

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@CoreyS 

Sounds you need a Blick Until Done Tool.

Say first branch outputs the data, then use second branch to join with input data of output from Branch 1.

 

Qiu_0-1613688870027.png

 

CoreyS
8 - Asteroid

@Qiu ,

 

Thanks for the quick reply!

 

I can't seem to find the 'Block Until Done' tool. Does that require special access?

 

Respectfully,

Corey

Qiu
21 - Polaris
21 - Polaris

@CoreyS 

That is strange. What version are you using?

It is under the Developer Category.

Capture12.PNG

CoreyS
8 - Asteroid

@Qiu 

 

Thanks! I didn't have developer as a selection on my Toolbar. I added it and now it's there.

 

I appreciate the continued support!

 

Respectfully,

Corey

Qiu
21 - Polaris
21 - Polaris

@CoreyS 

Glad to help though it is just small, and thank you for the accept mark.

Labels