Hi All --
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.
Thanks for your help.
Seth
Solved! Go to Solution.
Hey @smoskowitz
There are more elegant solutions to accomplish this, but attached should get to what you're after, and hopefully provides a good walk through of the logic needed to accomplish this in the future.
Cheers,
Nick
photo finish, @CharlieS!!!
This is one of my favorite things about both Alteryx and the Alteryx Community. In less than 30 minutes, look at all the different solutions offered up for the same problem!
Love it!
True that @gene_denny! An immeasurable advantage of using this tool vs. others, is the strength and engagement of the community :)
I want to thank everyone for their help! I agree that this community is so awesome!