I am trying to create a 5 yr GL Code to Tax Master Code for the group. However, in 2021 the team changed the Tax Master Codes. I am having trouble creating the desired output. The challenges I am facing:
- Duplicated Unit #'s with many of the same GL Acct Code
- Duplicated GL Account codes on separate lines due to different Tax Master Codes
- Amounts for 2021 are on a separate line due to a different Tax Master Code
I am trying to create a unique line for each Unit by GL Code with the 2021 amounts presented on the same row.
Does anyone know if this is possible to do in Alteryx? I have attached the Input and Desired Output workflow.
