How do I format the two inputs below to create the desired Output

Question

I have two inputs. The first displays the a group, group's income & expense and the differences.  The second input shows the breakdown of those differences. How do I combine this two date to derive the output below in Alteryx. I have attached the input file.

Input 1

Input 2

Output:

Sample.xlsx

avarty · Answer

Hi HafeezA - that should be possible with a mix of transform functions and a join between the data set. The attached workflow does produce the output, however it does replicate the Group for each row. It is generally a good practice to retain that field for all rows so I left within, but you could use a multifield function to remove it if needed. Hope that helps!

New Workflow1.yxmd