I have been struggling with how to apply two sets of rules to a particular column, and have had a bear of a time. Here is what I want to do.
Scenario 1: I created groups based on my information. The group is designated by the first column (Tile_Num).
If you look at the column labeled Concat_Transaction ID -- three of the rows have data and three are null. For this group (and this instance_ I just want to keep the three rows with data (2017-Q2_10631). The ones with NULL can be discarded.
Scenario 2: For Tile_Num 68 - If the Concat_Transaction ID has no data in it, then just keep the first row of data.
In this scenario, I would expect to just be able to return the first row listed.
I cannot for the life of me figure out how to write this filter. Data is attached.
See the attached workflow. I'd first filter the records that have something in the field, then remove all other records that are part of that group (unjoined R side of join tool). After that, a sample tool will do the job for taking the first record of each group.