topic Re: Fields from different tables in one if statement in QlikView

Fields from different tables in one if statement

nicolai_moller — Fri, 28 Jun 2013 08:26:34 GMT

I need to create an if statement that uses fields from two different fields.

Something like this.

load

FROM ...

load

FROM ...

load

if(A>B,1,0) as TEST

resident ?

So I guess I have to create the IF statement in a third table? But how do I link them together?

Thanks.

Re: Fields from different tables in one if statement

Fri, 28 Jun 2013 08:33:16 GMT

you must have an relation between column A and B (join the tables or union them in one table and you can do that)

Re: Fields from different tables in one if statement

Fri, 28 Jun 2013 08:42:12 GMT

let say tab1:

id A

1 data1

2 data2

3 data3

4 data4

let say tab2:

id B

1 val1

2 val2

3 val3

4 val4

if you

*****************

left join (tab1)

load * resident tab2;

****************

will modify tab1 like:

id A B

1 data1 val1

2 data2 val2

3 data3 val3

4 data4 val4

and after that you can load (because now he knows to compare on every row).

Make sure you have a field (this case id) that is the same in both table , this is where the join is made.

load *,

if(A>B,1,0) AS TEST

resident tab1;

Hope that helps.

Re: Fields from different tables in one if statement

Fri, 28 Jun 2013 08:43:48 GMT

try this

table1:

load

rowno() as key

FROM table1;

outer join

table2:

load

rowno() as key

FROM table2;

table3:

load

if(A>B,1,0) as TEST

resident table1;