topic Table Preview option Disabled ! in QlikView

Table Preview option Disabled !

pradeep92 — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Table Preview option Disabled !

devarasu07 — Mon, 09 Oct 2017 08:38:55 GMT

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

Re: Table Preview option Disabled !

tresB — Mon, 09 Oct 2017 08:47:45 GMT

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) ;

Re: Table Preview option Disabled !

pradeep92 — Mon, 09 Oct 2017 09:55:13 GMT

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

Re: Table Preview option Disabled !

pradeep92 — Mon, 09 Oct 2017 09:55:31 GMT

Thank you !

Re: Table Preview option Disabled !

devarasu07 — Mon, 09 Oct 2017 10:01:07 GMT

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