Filtering out rows based on the same value in two columns

overhead_press

Hi everyone, how would I go about filtering out data that are the same in Amount1 and Amount2 column grouped by the Account number? Thanks!

Original:

Account	Amount1	Amount2
1	100
1		100
2	200
2		200
3	300
4		300

Desire result:

Account	Amount1	Amount2
1	100
1		100
2	200
2		200

mceleavey

Hi @overhead_press ,

I've built the attached workflow for you.

This pivots the data so the values are in the same column, it then removes empty values, pivots back to compare values for the same account number on the same line. Once we've determined the ones that match, use the Account to join back.

Hope this helps,

M.

mceleavey_solution.yxmd