topic Re: NULL values in script in App Development

NULL values in script

stekol61 — Tue, 10 Mar 2020 12:10:10 GMT

Hi!

I'm loading ticket data with some different date fields:

If (not isnull(inc_wip_date), inc_wip_date, inc_cleared_date) as inc_wip_date,

if(not isnull(inc_wip_date),'1','0') as script_wip_Null_check,

inc_ID,
inc_cleared_date,
inc_create_date
// inc_wip_date,
FROM

The result looks like this:

The 'inc_wip_date' is modified by the first expression in the load script. The original value of 'inc_wip_date' is NULL for this ticket.

The 'script_wip_Null_check' expression see this as a NULL value.

I want to use this modified 'inc_wip_date' in an expression but since seems to be a NULL value it will not be possible to use.

How can this be handled?

Re: NULL values in script

nikitadeshwal — Tue, 10 Mar 2020 17:59:51 GMT

Hi,

Try to write this expression

if(not isnull(inc_wip_date),'1','0') as script_wip_Null_check

in preceding load and check result.

Re: NULL values in script

stekol61 — Wed, 11 Mar 2020 08:22:19 GMT

Hi!

I updated the LOAD script as below but the result is still the same.

If (not isnull(inc_wip_date), inc_wip_date, inc_cleared_date) as inc_wip_date,

inc_ID,
inc_start_date,
inc_cleared_date,
inc_pending_date,
inc_create_date,
// inc_wip_date,

if(not isnull(inc_wip_date),'1','0') as script_wip_Null_check

FROM

/Stefan

Re: NULL values in script

nikitadeshwal — Wed, 11 Mar 2020 10:10:00 GMT

Hi,

Try below code and check again

load *,
if(not isnull(inc_wip_date1),'1','0') as script_wip_Null_check;
load *,
If (not isnull(inc_wip_date), inc_wip_date, inc_cleared_date) as inc_wip_date1;
Load
inc_ID,
inc_start_date,
inc_cleared_date,
inc_pending_date,
inc_create_date,
inc_wip_date,

FROM ....

Thanks

Nikita Deshwal