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 ?
Hi @HafeezA
Can you provide some sample input and expected output it will help us get a better understanding.
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 ?
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 : )