topic inline table with null valued column in QlikView

inline table with null valued column

ali_hijazi — Mon, 24 Oct 2011 09:09:11 GMT

Hello

I need to create a table using inline load

for example

myTable:

load * inline[

C1,C2

1, Ali

2, Jean

3, NULL

];

for the third row I want C2 to be null the above is considered as the string NULL

inline table with null valued column

lironbaram — Mon, 24 Oct 2011 09:13:04 GMT

change your load to

myTable:

load * inline[

C1,C2

1, Ali

2, Jean

3,

];

inline table with null valued column

ali_hijazi — Mon, 24 Oct 2011 09:14:39 GMT

I tried this out but gave syntax error

inline table with null valued column

its_anandrjs — Mon, 24 Oct 2011 09:16:35 GMT

Hi,

Use isnull( ) function and do not put any thing in the row.

myTable:

load * inline[

C1,C2

1, Ali

2, Jean

3,

];

It will automatically treated as null value.

Rgds

Anand

inline table with null valued column

lironbaram — Mon, 24 Oct 2011 09:21:14 GMT

ok

try this one

SET NULLINTERPRET =<sym>;
myTable:

LOAD * INLINE [
C1, C2
1, Ali
2, Jean
3,<sym>
];