Filter Specific Rows from Data

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!

Workflow

Tips and Tricks

Transformation

Preparation

Accepted answers

I attached a workflow that i think will work

I hope it helps

ExampleFilterDuplicates.yxmd

Thanks @aruiz-itp ! That worked!

All comments

I attached a workflow that i think will work

I hope it helps

ExampleFilterDuplicates.yxmd

Christine_Assaad

I tackled it a bit differently in case records won't be in order. Please check if this works for you. Cheers!

Filter rows from data.yxmd

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703