How to correctly union/combine two files?

Question

Hello helpers!

Thank you in advance!

I'm trying to combine two input files to obtain the result as attached file. Basically, to combine and sum information for the same date, same hotel, same outlet, same check number, same discode, for the total discroundamount, and shows the total fcktot per input file B.

I tried Union tool, summarize tool, but did not work :(

Can someone please help?

Input B.xlsx

Input A.xlsx

Result.xlsx

Raj · Answer

@Emmm 
find the Workflow attached
Mark done if solved.

3133.yxmd

Brinker · Answer

Hi @Emmm

You need to join on the fields you spesified if you want the the result set.

join.yxzp