Hello,
I'm hoping someone can help me determine the most efficient way to filter specific rows from a data set. Below is an example of the input and output I'm trying to achieve:
Essentially I only want to see scenarios where the TRX_NUMBER duplicates, yet the TAX_RATE_CODE is different. I think a Multi-Row formula would do the trick, but I'm a relatively new user and have difficulty with that tool.
Any assistance would be appreciated.
Thanks!
Solved! Go to Solution.
Hi @Jmacnevin
I tackled it a bit differently in case records won't be in order. Please check if this works for you. Cheers!
Thanks @aruiz-itp ! That worked!
Thanks @christine_assaad! That does work for me as well.
Hi @Jmacnevin You can use the summarize tool and filter in distinct count