Loading from CSV, WHERE CONTAINS/LIKE

Tue, 15 Nov 2011 07:25:32 GMT

I'm loading rows from csv

1/1/2011;1;foobar

1/2/2011;2;quickbrownfox

How can I filter the rows during load so that the text field has to have certain value?

LOAD

@1,

@2,

FROM

[..\data.csv]

WHERE

???

I've tried

@3 LIKE '%foo%'

@3 CONTAINS('foo')

@3 = '*foo*'

But can't figure out the right syntax. Thanks for any help on this.

Tue, 15 Nov 2011 09:04:06 GMT

Hello mlindman

it seems that you are quite close, try this:

. . .

WHERE(@1 like '*foo*');

topic Loading from CSV, WHERE CONTAINS/LIKE in QlikView