Loop in a script

[TomBond77]

Hi experts

I have this loading script:

[fact_temp]:

....

if(monthend(date(floor(Timestamp), 'YYYY-MMM'))= monthend(date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM')), [Event Reason]) as [Event Reason_new]

Now I need to overwrite [Event Reason] by [Event Reason_new], the statement below is not sufficient. Do yu

[Fact]:

Load *,
if(Leaver=1 and isNull([Voluntary/Involuntary]), [Event Reason_new], [Event Reason_old]) as [Event Reason]
Resident [fact_temp];

Any ideas how to solve?

[Anil_Babu_Samineni]

@TomBond77 Perhaps the null is not really null? You can replace null with Len() if that helps.

if(Leaver=1 and Len([Voluntary/Involuntary])=0, [Event Reason_new], [Event Reason_old]) as [Event Reason]