reloading csv files with where clause

[#1]

I have a csv file which pulls data into Qlikview.

On reload this works fine, however when I put a where clause at the end Im getting this error

----------------------------------------------------------------------

Cannot open file 'test.csv]

WHERE col1 = '307'

[material]:

NOCONCATENATE

LOAD col1,

     col2,

     col1 & ' - ' & col2 as g_product

FROM [test.csv]

WHERE col1 = '307'

-----------------------------------------------------------------------

I have the semi-colon at the end of my where clause but its not in the error message.

[SunilChauhan · Accepted solution]

take resident and apply where clause

[jagan]

Hi,

You can you also do like this.

LOAD

     *

WHERE col1 = '307';

LOAD col1,

     col2,

     col1 & ' - ' & col2 as g_product

FROM [test.csv];

Regards,

jagan.