community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Join back a Summarize table

Asteroid

Hi,

 

I am currently working on a flow, where the original Input data has about 20 fields and I summarized the data with 2 fields (Customers and Amount) by using Summarized icon.  I then filtered the summarized data using Filter icon.  I don't care about the TRUE data at the moment, but how do I join back the FALSE data back to the original input data knowing the amount has been summarized?

 

Thanks!

Highlighted
Asteroid

Hi @yzhang316

 

You are going to want to use the join tool with the false output of your filter tool (left or right, doesn't matter) and the original input tool as your other side of the join. 

 

From there you will set the join to be on Customers = Customers. Take the value from the J output. This should have your original data schema + Sum_Amount. 

 

Let me know how this works for you. 

 

Thanks,

Cameron

Asteroid

Worked!  I had an error while joining the two tables before, but it is fixed! 

Labels