Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Loading from CSV, WHERE CONTAINS/LIKE

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,

    @3

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.

1 Solution

Accepted Solutions
Not applicable

Loading from CSV, WHERE CONTAINS/LIKE

Hello mlindman

it seems that you are quite close, try this:

. . .

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

RR

1 Reply
Not applicable

Loading from CSV, WHERE CONTAINS/LIKE

Hello mlindman

it seems that you are quite close, try this:

. . .

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

RR

Community Browser