Filling nulls

[#1]

Hi All,

I have a link table with nulls i need to replace with actual date.

"Link Date nulls to be replaced with Task_closed_at "

[kaushiknsolanki]

Hi,

Change your script part to below.

Temp2:

Load *,num(interval(task_closed_at-[Link Date]),'#,##0') as age;

Load *,

//task_closed_at,

//if(isnull(task_opened_at), task_closed_at,task_opened_at) as task_opened_at,

if(Isnull([Link Date]),task_closed_at,[Link Date]) as [Link Date],

task_opened_at,

     task_closed_at

Resident Temp;

Regards,

Kaushik Solanki

[#3]

Its not working the same result with nulls.

[Anonymous]

Hi,

Are you getting any error message if you follow Kaushik Script?

[#5]

No,but its giving same results what i have

[kaushiknsolanki]

Hi,

Kindly upload the PENDING.xls file so that I can reload the application and check the issue.

Regards,

Kaushik Solanki

[#7]

PFA of pending.xls

[kaushiknsolanki · Accepted solution]

Hi,

Have a look at the attached application.

Regards,

Kaushik Solanki

[petter]

This seems to be a cross-post of exactly the same issue on the same application made by two different members... Really strange. Please don't cross post - it waste a lot of time for others trying to help and it is very disrespectful.

Date generating issues