Aggregated Transaction Matching

[Dittau]

If i am running a concatenate between 2 files daily and matching based on certain fields (soda, food, quantity) lets say. One of the inputs is a data warehouse and the other is what i am trying to determine if it is in the warehouse.

how would i have it check to see if there is an aggregated amount that equals the data warehouse to go with my current concatenate?

ex below: how do i have it say rhis input set matches with the below data set and also would matxh 1 for 1 with the same soda food and quantity if it was in the datat warehouse the exact same way to?

input set

soda        Food       Quantiy

water    chicken           2

water    chicken           3

water      chicken          5

water       chicken         5

warehouse set

soda       Food        Quantity

water    Chicken         15

[ShankerV]

Hi @Dittau 

1. First use the Summarize tool to get the values in total.

2. Then match with the warehouse dataset

[ShankerV · Accepted solution]

Hi @Dittau 

A sample use case to explain the scenario.

Many thanks

Shanker V

[gautiergodard · Accepted solution]

hey @Dittau 

perhaps you could try something like the attached?