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:
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!