Discussion Board for collaboration on QlikView Scripting.
I have a table that has job titles for a slew of people with dates where they started and ended:
LOAD * INLINE [
NAME, Start, End, JOB_CODE
Jeff, 2010-10-01, 2012-09-30, CHIEF
Jeff, 2012-10-01, , BIG_CHIEF
Garfield, 2011-10-01, 2013-09-30, BALLER
Garfield, 2013-10-01, 2014-06-01, LOW_BALLER
I have Expense accounts and I want to know their job code when they made this expense:
NAME, DESCRIPTION, DATE, EXP_ID
Jeff, Headress, 2012-06-01, 1
Jeff, Funky shoes, 2014-01-01, 2
Garfiled, Lasagna, 2011-11-30, 3
Garfield, Pizza, 2013-11-30, 4
I would end up with something like:
NAME, DESCRIPTION, DATE, EXP_ID, JOB_CODE
Jeff, Headress, 2012-06-01, 1, CHIEF
Jeff, Funky shoes, 2014-01-01, 2, BIG_CHIEF
Garfiled, Lasagna, 2011-11-30, 3, BALLER
Garfield, Pizza, 2013-11-30, 4, LOW_BALLER
Just an interval match doesn't work because I have more than one criteria. I was wondering if it was an issue of createit fit in an interval match function...
Any help here understanding the interval match possibilities?
Sorry. My first attachment had a misspelling in the name. The below should work for you:
View solution in original post