Filter Values

Need help with something easy but I can't seem to come up with elegant solution. I attached a file with input and output I am looking for. Basically trying to take the 3 most recent dates from data in INPUT (jul/aug/sep) and filter so that each Num (column must contain the 3 dates. In my example, only Num values 1 and 5 should come through and 2,3,4 should be left out.

Thanks in advance!

community 20221020.xlsx

Join

Preparation

Accepted answers

JamesCharnley

Hi @bertal34,

I get the feeling this is one of my solutions that somebody can do more elegantly, but this should dynamically take those max 3 dates by Sampling, and finding instances where all three are contained by the numbers using the Summarize and Join tools.

Top 3 Dates Filter.yxmd

All comments

JamesCharnley

Hi @bertal34,

Top 3 Dates Filter.yxmd

davidskaife

Hi @bertal34

Here is one way of doing it; you could exchange the 'IN' clause for the test column to be whichever month(s) you required, and the filter tool value accordingly.

Filter.yxmd

binu_acs

@bertal34 One way of doing this

Date_1020.yxmd

bertal34

Thank you @JamesCharnley this works perfectly!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703