topic reloading csv files with where clause in QlikView

reloading csv files with where clause

Tue, 29 Nov 2011 12:19:13 GMT

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 — Tue, 29 Nov 2011 12:21:08 GMT

take resident and apply where clause

jagan — Tue, 29 Nov 2011 12:51:48 GMT

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.