Hello,
So I have a dilemma, we have transaction data getting pulled into alteryx and there is a need to update a column within the workflow based off set criteria.
We have transactions that come in with gratuity assigned to them, so we have a few records for the same transaction but with differing amount, source_account, and tender_type columns. They share the same transaction_reference however. I need a way to turn the original output:
(filtered to only show relevant transaction)
Into this Desired Output:
This needs to be done dynamically without interfering with other transactions, especially those that have the same source_account of "Food".
What I am trying to do is replace the tender_type column for records with a source_account of "Food", and share the same transaction reference, with what is in the source_account for the actual total from the transaction (source_account prefixed with "HC ").
