so, I want to calculate some flag values.. basically, I want to do something like this..
if((personName = 1) and (todaysDate >= fieldStartDate) and (todaysDate <= fieldEndDate), 1, 0), as IsThereaRealPersonHereStatus
can I have this complex if statement in the data load script?
if(personName = 1 and todaysDate >= fieldStartDate and todaysDate <= fieldEndDate, 1, 0) as IsThereaRealPersonHereStatus
I ended up doing personName * (todaysDate >= fieldStartDate) * (todaysDate <= fieldEndDate) as TheresaRealPersonHereStatus
it seems to work..
Retrieving data ...