Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
stephbzr
Contributor III
Contributor III

SELECT statement with WHERE

Hello,

I am trying to execute a SELECT query with WHERE from a file name. But I get the following error: 

I can't find what the problem is. Can you help me or tell me if there is another way? 

Also, I am trying to do 2 processing flow. If the query returns at least one line then flow1. But if the query does not return any rows then flow2. Can you give me an idea? 

0695b00000WumTaAAJ.png

0695b00000WumUsAAJ.png

Labels (4)
1 Reply
Anonymous
Not applicable

In this case try to check the Generated Java code, by clicking on the Code tab.

 

The solution will be to chnage that last line:

nom_fic = '+ to:

nom_fic ='" +

and at the end of the line:

+ "'"