Load empty dates with the date of today

[Qliksense_77]

Hi,

I have data like below. If there is no disharce date yet, then the is "blank". 

I am searching for a method to fill the blank discharge dates with the date of today. I would like to do it in the load script and to have a new "discharge" date field similar to red field below.  

Can somebody help, please?

Id	Arrival date	Discharge date	New "discharge date" field
1	01-01-2021	04-01-2021	04-01-2021
2	07-07-2021	10-07-2021	10-07-2021
3	07-09-2021	Blank	08-09-2021	Date of today
4	08-09-2021	Blank	08-09-2021	Date of today

[Digvijay_Singh]

Something like this in the script - 

If(len([Discharge date]>0,[Discharge date],today()) as [New Discharge date]

Thanks,

[Vegar · Accepted solution]

Try uing the alt - script and chart function to solve this.

LOAD   
   [Arrival date],
   [Discharge date],
   ALT([Discharge date], today()) as [New Discharge date]
FROM ....

[Qliksense_77]

Thanks for helping @Vegar  and @Digvijay_Singh ,

I got the solution from Vegar to work.