Using Variable in Where Statement

[markgraham123]

Hello Everyone,

I'm trying to use Variable in Where statement which has multiple values.

Can someone pls look into this.

[sunny_talwar · Accepted solution]

Try these modifications:

Table:

LOAD * INLINE [

    FieldA

    1

    1

    2

    3

    4

];

// Create a temporary table

tmp:

NoConcatenate

Load concat(Distinct FieldA,',') as FieldA

Resident Table;

let vVar1 = peek('FieldA',0,'tmp');

// drop the temporary table

drop table tmp;

Table2:

LOAD * INLINE [

    FieldB

    1

    1

    2

    12

    13

    15

    16

    3

    4

];

2:

NoConcatenate

LOAD * Resident Table2

Where

Match(FieldB, $(vVar1));

DROP Table Table, Table2;

[Gysbert_Wassenaar]

Try Where match(FieldB,$(vVar1));

[maxgro]

Table:

LOAD * INLINE [

    FieldA

    1

    1

    2

    3

    4

];

// Create a temporary table

tmp:

NoConcatenate

Load concat(Distinct FieldA,',') as FieldA

Resident Table;

let vVar1 = peek('FieldA',0,'tmp');

// drop the temporary table

drop table tmp;

Table2:

LOAD * INLINE [

    FieldB

    1

    1

    2

    12

    13

    15

    16

    3

    4

];

Table3:

NoConcatenate LOAD * Resident Table2

Where

match(FieldB, $(vVar1));

DROP Table Table2;

[markgraham123]

Thanks a lot Sunny!

[markgraham123]

Thanks Gysbert

It worked.

[markgraham123]

Thanks M G.