We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Summarize with identifiers from a different file

HafeezA
7 - Meteor

Hello, I am trying to replicate a SUMIFS  formula that uses 2 unique identifier fields from another file to group values values form a second file. How do I go about doing this ?

 

File one consists of key field and group field.

 

File two consists of a key and group field too and also the desired "price"  field.

 

How do I use the key and group fields in file one to summarize the "price" field in file two. Will a join tool work ?

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @HafeezA 

 

Can you provide some sample input and expected output it will help us get a better understanding.

HafeezA
7 - Meteor

File one consists of key field and group field.

 

File two consists of a key and group field too and also the desired "price"  field.

 

How do I use the key and group fields in file one to summarize the "price" field in file two. Will a join tool work ?

atcodedog05
22 - Nova
22 - Nova

Hi @HafeezA 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1630338904042.png

 

1. Use join tool to map groups

2. Using summarize on groups.

 

Hope this helps : )

Labels
Top Solution Authors