Handling NULL values in INTERVAL MATCH:

[#1]

Hi,

I have a question on using interval match handling null values. Below is my table structure

RANGE_SELECTION:
LOAD * INLINE [
MIN_TEMP, MAX_TEMP, SLR_PCT_AGGR_RANGE_TEMP
-1000000, 0.099999999, '< 1%'
0.1, 0.24999999, '1% - 25%'
0.1, 0.32999999, '1% - 33%'
0.1, 0.49999999, '1% - 50%'
0.1, 0.65999999, '1% - 66%'
0.1, 0.74999999, '1% - 75%'
0.1, 0.79999999, '1% - 80%'
0.1, 0.89999999, '1% - 90%'
0.9, 10000.89999999, '90% +'
];

RANGE:
Inner Join (RANGE_SELECTION)
INTERVALMATCH (PCT) Load MIN_TEMP, MAX_TEMP RESIDENT RANGE_SELECTION;

I also want to include NULL values in the above table like whenever PCT is NULL, it should display 'NA'. I tried below load, but it was wrong
i.e.,
LOAD * INLINE [
MIN_TEMP, MAX_TEMP, SLR_PCT_AGGR_RANGE_TEMP
-1000000, 0.099999999, '< 1%'
0.1, 0.24999999, '1% - 25%'
0.1, 0.32999999, '1% - 33%'
0.1, 0.49999999, '1% - 50%'
0.1, 0.65999999, '1% - 66%'
0.1, 0.74999999, '1% - 75%'
0.1, 0.79999999, '1% - 80%'
0.1, 0.89999999, '1% - 90%'
0.9, 10000.89999999, '90% +'
, , 'NA'
];

I tried the above syntax, but it is not working for null values. I am not sure, how to define min and max for null. Can anybody help me out.

[#2]

Null value for inlineLoad leave blank with , seperated

LOAD * INLINE [
MIN_TEMP, MAX_TEMP, SLR_PCT_AGGR_RANGE_TEMP
-1000000, 0.099999999, '< 1%'
0.1, 0.24999999, '1% - 25%'
0.1, 0.32999999, '1% - 33%'
0.1, 0.49999999, '1% - 50%'
0.1, 0.65999999, '1% - 66%'
0.1, 0.74999999, '1% - 75%'
0.1, 0.79999999, '1% - 80%'
0.1, 0.89999999, '1% - 90%'
0.9, 10000.89999999, '90% +'
, , 'NA'
];

[#3]

Hi devang

Thanks for the reply. I tried it and it is also not working

[#4]

Not sure what you are looking for, but in help

please look for IntervalMatch (Extended Syntax).

[#5]

I tried using 'NULLASVALUE' before intervalmatch and he it doesn't help either. Basically, I want null values of PCT to be shown in the range 'NA', but this doesn't show NULL values

[#6]

I tried using 'NULLASVALUE' before intervalmatch and it doesn't help either. Basically, I want null values of PCT to be shown in the range 'NA', but this doesn't show NULL values