topic Re: Load several times from a list in QlikView

Load several times from a list

Wed, 23 Apr 2014 15:52:59 GMT

I need to load data from several sources, but the clause WHERE it's the same.

[Source1]:

LOAD * FROM Table01

WHERE Match(CodeArea,101,106,109,125,129,131) > 0;

[Source2]:

LOAD * FROM Table02

WHERE Match(CodeArea,101,106,109,125,129,131) > 0;

[Source3]:

LOAD * FROM Table03

WHERE Match(CodeArea,101,106,109,125,129,131) > 0;

I can make a variable with the values (101, 106, 109, 125, 129, 131)? And use it in the script?

Let AreaValues = '101, 106, 109, 125, 129, 131';

[Source4]:

LOAD * FROM Table03

WHERE Match(CodeArea,AreaValues) > 0;

Thanks

Re: Load several times from a list

MK_QSL — Wed, 23 Apr 2014 15:56:22 GMT

For i = 1 to 3

Load * From Table$(i)

WHERE Match(CodeArea,101,106,109,125,129,131) > 0;

Next i

Re: Load several times from a list

its_anandrjs — Wed, 23 Apr 2014 15:58:30 GMT

Create a variable like

Let AreaValues =Concat(CodeArea,',');

Re: Load several times from a list

its_anandrjs — Wed, 23 Apr 2014 16:00:32 GMT

Then use in a code like

Let AreaValues =Concat(CodeArea,',');

[Source1]:

LOAD * FROM Table01

WHERE Match(CodeArea,AreaValues) > 0;

[Source2]:

LOAD * FROM Table02

WHERE Match(CodeArea,AreaValues) > 0;

[Source3]:

LOAD * FROM Table03

WHERE Match(CodeArea,AreaValues) > 0;

Re: Load several times from a list

Wed, 23 Apr 2014 16:28:14 GMT

Anand, and where can I write the values 101,106,109,125,129,131?

Thank.

Re: Load several times from a list

its_anandrjs — Wed, 23 Apr 2014 16:34:22 GMT

Create one inline table like below and you can create many according to your match criteria.

Eg:-

Load * Inline[

MatchAreaValues

101

106

109

125

129

131

];

Let AreaValues =Concat(MatchAreaValues,',');

And then use

[Source1]:

LOAD * FROM Table01

WHERE Match(CodeArea,AreaValues) > 0;

[Source2]:

LOAD * FROM Table02

WHERE Match(CodeArea,AreaValues) > 0;

[Source3]:

LOAD * FROM Table03

WHERE Match(CodeArea,AreaValues) > 0;