Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
AIShatiLove
Contributor III
Contributor III

load where

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

Labels (1)
2 Solutions

Accepted Solutions
Taoufiq_Zarra

@AIShatiLove 

Maye be

 

load

...

From File

where ...;

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Chanty4u
MVP
MVP

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;


View solution in original post

3 Replies
Taoufiq_Zarra

@AIShatiLove 

Maye be

 

load

...

From File

where ...;

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Chanty4u
MVP
MVP

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
Contributor
Contributor

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?