Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Where clause issue

Initially when i was loading from QVD, these where clauses work sucesssfully, but now the script hangs when i load from the foxpro .db

WHERE LEFT(clicod,1) = 'B';

WHERE NOT clicod = 'IN' and NOT LEFT(clicod,1) = 'B';

1 Solution

Accepted Solutions
Not applicable
Author

Maybe with : WHERE clicod <> 'IN' and LEFT(clicod,1) <> 'B';

View solution in original post

2 Replies
Not applicable
Author

Maybe with : WHERE clicod <> 'IN' and LEFT(clicod,1) <> 'B';

er_mohit
Master II
Master II

try to work this Code before Load Your Table from foxpro.db

means in preceding load

like

load A,

B

where B=10;

load * from foxpro.db;