Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
below link i checked
Mapt - Developer skills delivered
I am bit confused on below ISnull scenario Can anyone give some clarification on this?
Data:
Load
Country,
If(IsNull(Sales), 0, Sales) As Sales
Inline [
Country, Sales
USA, 1020
UK, 965
Germany,
France, 890
];
if i use --- If(IsNull(Sales), 0, Sales) As Sales this condition still giving same results if not also same.
how it is used?
Inline load is like text file, it can't contain NULL values. If you want to get the impact of NULL in inline load try like:
Set NullInterpret = '';
Data:
Load
Country,
If(IsNull(Sales), 0, Sales) As Sales
Inline [
Country, Sales
USA, 1020
UK, 965
Germany,
France, 890
];
Inline load is like text file, it can't contain NULL values. If you want to get the impact of NULL in inline load try like:
Set NullInterpret = '';
Data:
Load
Country,
If(IsNull(Sales), 0, Sales) As Sales
Inline [
Country, Sales
USA, 1020
UK, 965
Germany,
France, 890
];
You can use Alt() that returns the first non-null values
so,
If(IsNull(Sales), 0, Sales) == Alt(Sales,0)
thanks Tresesco
its working as expcected
thanks vineet
Hi Chanty,
you should define null value then it will work fine.
Regards
Sathish
yes satti its working fine now