How to align rows for subtraction? Need identifiers.

Question

Hi,

I have values that need to be subtracted but the row names do not match.

How can I align these to do a subtraction?

side A:

side B:

this is just sample data. But the rows "Name" arent the same but the #'s are supposed to be aligned so it can be suctracted to 0.

How can I create identical identifiers to match the records?

Thanks.

IraWatt · Answer

@wonka1234 here's one way which should be quite dynamic at large scale:

One thing to note is you cant have columns with the same name in Alteryx.

Workflow.yxmd

wonka1234 · Answer

i would need to do this at a large scale. It seems like i need a way to manually order rows.

wonka1234 · Answer

@IraWatt   final output:

NameValueNameValueCMB Coupon Payment (incl.expenses)-80347992.77PYMT (Seller Swap)_Transfer User-80347992.77Swap interest receipt via CPA (incl.expenses)20210839.98FloatingInt_TransferUser20210839.98

Then from here I can do a subtraction