Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 "
Hi,
Have a look at the attached application.
Regards,
Kaushik Solanki
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
Its not working the same result with nulls.
Hi,
Are you getting any error message if you follow Kaushik Script?
No,but its giving same results what i have
Hi,
Kindly upload the PENDING.xls file so that I can reload the application and check the issue.
Regards,
Kaushik Solanki
PFA of pending.xls
Hi,
Have a look at the attached application.
Regards,
Kaushik Solanki
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.