Well it works (...sort of). I'll mess with it and try to make it fix my need. I guess I was thinking that Tableau had some function that would simply look through the Holiday Table and return a "True" or "False" when compared to a different column of data (...in a different table).
...but thanks for what you gave...it works but I don't know how and I'm trying to figure out how to add this to a larger mix.
There is no vlookup function like excel.
I blended two data sources
1) 7/1/16 - 7/4/16
2) 7/4/16 only
You can have it return true/false if you want, you asked for "holiday". I added the true/false to the attached 9.2 workbook.
Blend.twbx 17.6 KB
I got it to work…many thanks. Just had to get my head out of Excel.
Thanks! Got it to work! Just had to think through it.
You don't need that 2nd date field in there, it was just illustrative purposes. Drag it out and keep just the holiday field you want.