Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi, how to use "where" statement when loading your data from a file
Maye be
load
...
From File
where ...;
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;
Maye be
load
...
From File
where ...;
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;
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?