Remove columns data

[bharatkishore]

HI All,

I have written the below condition to get flag in script:

if(Equipment=Equipment_Sales_LookUp

and Posting.Date>=Start_DT_New and Posting.Date<=End_DT_New,'Contract Period','Outside Contract Period' )as Contract_Flag

Now the problem is when  i have data as Outside Contract Period i want to get the few fields data as null. i don't want to see any records . Can you please suggest me on this. 

This should happen in script and all the fields are in 1 table.

Thanks,

Bharat

[PrashantSangle]

for time being I am debugging your expression only so remove 1st condition from your exisiting expression
if(num(Posting.Date)>=num(Start_DT_New) and num(Posting.Date)<=num(End_DT_New),'Contract Period','Outside Contract Period' )as Contract_Flag,

Regards,
Prashant Sangle

[bharatkishore]

PFA imabe.. this is the result i got after your condition. please let me know if you need anything more..

[PrashantSangle]

Now add one more expression which will test your 1st condition
if(Equipment=Equipment_Sales_LookUp,'True','False') as Flag

Regards,
Prashant Sangle