topic Re: Load csv file with condition in QlikView

Load csv file with condition

Anonymous — Thu, 10 Sep 2015 19:17:19 GMT

Hi guys,

Is it doable to load csv file with condition IN ()

LOAD SessionID,

Url,

TimeStamp,

ValidData

FROM

(txt, codepage is 1251, embedded labels, delimiter is ',', msq)

WHERE (SessionID in ($(vValue)))

Order by SessionId, [TimeStamp] ASC;

Thanks,

sinanozdemir — Thu, 10 Sep 2015 19:22:11 GMT

I think it should work if you put the variable within single quotes:

WHERE (SessionID in ('$(vValue)'))

maxgro — Thu, 10 Sep 2015 19:29:06 GMT

example with resident

Table:

LOAD * Inline [

Customer, Date, Mode

A, 01/01/2015, Cash

A, 02/01/2015, CreditCard

A1, 02/01/2015, CreditCard

A1, 03/01/2015, Cash

A1, 04/01/2015, Check

A2, 01/01/2015, Cash

A2, 02/01/2015, CreditCard

B, 02/01/2015, Check

];

let v=chr(39) & 'Cash' & chr(39) & ',' & chr(39) & 'Check' & chr(39);

TableFiltered:

NoConcatenate

load *, 1 as NewField Resident Table

where match(Mode, $(v));

Anonymous — Thu, 10 Sep 2015 19:44:26 GMT

Thank you.