How to correctly union/combine two files?

[Emmm]

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? 

[Brinker]

Hi @Emmm 

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

[Raj]

@Emmm 
find the Workflow attached
Mark done if solved.