Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to use Where clause in the Load part (not in the SQL Select part) with Qlik sense?
Any suggestion is appreciated!
Yes. It's simple and similar like in SQL Select:
Load
Field1,
Field2
From <> Where Field1> 100;
Check this out: Video Link : 4112
HTH
Yes. It's simple and similar like in SQL Select:
Load
Field1,
Field2
From <> Where Field1> 100;
Thanks tresesco,
It works.
LOAD
[column1],
[column2]
FROM <>
Where [column1]=1;