Summarize with identifiers from a different file

Question

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 ?

atcodedog05 · Answer

Hi @HafeezA

Here is how you can do it.

Workflow:

1. Use join tool to map groups

2. Using summarize on groups.

Hope this helps : )

map and groupby.yxmd

HafeezA · Answer

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 · Answer

Hi @HafeezA

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