Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
t1:
load * inline[
name, salary
a,12
b,1232
c,24314
d,2144
e,2134
f,435665
,6878
]
where isnot null(Name);
I have written this code, but still my null values are coming.
So please help me out.
[temp]:
LOAD * INLINE [
name, salary
a, 12
b, 1232
c,24314
d,2144
e,2134
f,435665
,6878
];
NoConcatenate [temp1]:
load * Resident [temp] where not isnull(name) and name <> '';
DROP Table [temp];
[temp]:
LOAD * INLINE [
name, salary
a, 12
b, 1232
c,24314
d,2144
e,2134
f,435665
,6878
];
NoConcatenate [temp1]:
load * Resident [temp] where not isnull(name) and name <> '';
DROP Table [temp];