Table Preview option Disabled !

[pradeep92]

Hi,

I have a table

Emp1:

LOAD * INLINE [

    FirstName, LastName

    John, Smith

    Adam, Power

    Peter, Goldman

     ,Value

] where exists(FirstName) / where isnull(FirstName) ;

After reload, When I check in table viewer (CTRL + T), it doesnt load any data .. Shows 0 records and table preview is disabled.

Can someone please help?

[devarasu07]

Hi,

Try like this.

Emp1:

LOAD * INLINE [

    FirstName, LastName

    John, Smith

    Adam, Power

    Peter, Goldman

     ,Value

] where len(FirstName)=0;

Hope this helps to you

[tresesco]

If you want to get null from inline table, you could NullInterpret system variable like:

Set NullInterpret='';

LOAD * INLINE [

    FirstName, LastName

    John, Smith

    Adam, Power

    Peter, Goldman

     ,Value

] where  isnull(FirstName) ;

[pradeep92]

Hi, Thank you so much for the quick reponse. Is it just because There was no data ,the table viewer option was disabled right ?

[pradeep92]

Thank you !

[devarasu07 · Accepted solution]

Hi

We have the value but it might be blank or null so the len(FirstName)=0; will take care of NULLs and blanks.

Hope this helps to you

Once your question answered try to close this thread by marking as correct. Thanks

P.S: check this article for more details

NULL handling in QlikView

Regards,

Deva