Challenge #333: Remote or Not Remote

[DataNath]

My solution to #333.

Spoiler

[calpav]

Here is my solution! If anyone can explain to me why I can't use the duplicate anchor of a Unique Tool instead of the Summarize, Filter, and Join combination I had to go with to only look at job titles that occurred more than once.

Thanks!

[Watermark]

Hint/Warning: Be aware of the 'order' you implement the criteria.

If you want the slightly harder aspect, match the order of the 'type' (remote/hybrid/onsite) to the results provided. Make sure your years are ascending as well. 

Spoiler

 

 

[patrick_digan]

Spoiler

[joelmiller66]

Spoiler

[binuacs]

Spoiler

[alex]

here ya go

Spoiler

[davidhardister]

Spoiler

[TonyAndriani]

Spoiler

[TonyAndriani]

@calpav, not sure how you are wanting to use the Unique tool here. If you use the tool to test for a value that appears in three different rows, one row will appear on the U anchor and the other two on the D anchor. So you can't just take the rows from the D anchor -- you'll be missing a row. You could use the Unique tool if you passed the D output data to another Unique or a Summarize to get the distinct set of values and joined that back to the original data. But I expect that Summarize, Filter, Join is faster.