Column Codes to Rows?

Question

Hi team, I hope all is well.

I've been working on a variance report for over a month now and I cant seem to place all of the memo codes and deduction codes onto one line with the correlating amount to the right side. Essentially, I need to review two reports from different dates and identify if there's a gross change. If there's a gross change, I need to know what memo code and deduction codes are correlated with said change. Attached is example 1 which is the current format and example 2 which is the format I think will work. The attached screenshot is of a workflow where I tried to work around my current problem but ultimately ended up burning in flames so hot I had to take a leave of absence.

AngelosPachis · Answer

Any update on that @jalizmaldonado ?

AngelosPachis · Answer

Hi @jalizmaldonado ,

Give the following workflow a try, I think it manages to bring your input into that single row format.

The field names unfortunately cannot be the same in Alteryx, so I have used an identifier (ID) at the front.

Let me know if that worked for you.

Cheers,

Angelos

example.yxmd

jalizmaldonado · Answer

Hi Angelos, I hope all is well.

I made changes to the original file and attached the edited version. Sheet 3 is the format I think I need to simplify this workflow.

Best,

Book2.xlsx