Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Regards,
Deva
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
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) ;
Hi, Thank you so much for the quick reponse. Is it just because There was no data ,the table viewer option was disabled right ?
Thank you !
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
Regards,
Deva