Load csv file with condition

[Anonymous]

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]

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

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

[maxgro · Accepted solution]

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]

Thank you.