load where

[AIShatiLove]

hi, how to use "where" statement when  loading your data from a file

[Taoufiq_Zarra · Accepted solution]

@AIShatiLove 

Maye be

load

...

From File

where ...;

[Chanty4u · Accepted solution]

can you tell me what you want in where codniton.   

below is small example you can use this way

[service2]:
LOAD
"$_serviceid" as [ServiceID],
....
"$_clientid" as [ClientID],
FROM [lib://QVDs/PHS QVDs DEV\service.qvd]

(qvd) WHERE [ClientID] = 37;

[QlikCompact01]

Hi!

When I try to use your solution, I'm getting an error:

Cannot open file: 'lib://DataFiles/Files.csv where 1=1'

I need to provide also a file type like below:

FROM lib://DataFiles/Files.csv (txt) where ...

Do you know in which case the editor requires the file type?