Alteryx merge two database and add rows

[Danilo9017]

Hi ! 

I hope this is the topic section is right for my question . 

I am struggling because i have these two files. I want to merge the file of increase and the file of "cr trial balance alternate ledger" and " increase 31.12.2020

The particularity of these merging is the following: 

I want to put the detail of "increase 31.12.2020" under the matching account of file Cr trial alternate ledger 

So for example in the file "cr trial balance alternate ledger"  under column F, row 5  i want to put the details of the matching account 14070702 (from file increase 31.12.2020) 

Is it possible to do it on alteryx? 

Danilo 

[Qiu]

@Danilo9017 
Perhaps you can give us an example of the output?

[Danilo9017]

Hi Qiu

Please find attached an example of output file

Danilo 

[CarliE · Accepted solution]

Hi @Danilo9017,

Attached is a workflow that give you the expected output.

If you found this helpful, and this solved your problem, please mark as a solution to help other users!

Best,

[Danilo9017]

Thanks @Carli 

There is way to display the amounts of increase in column  F? (i just downloaded the output from alteryx)