topic Re: Accesing fields from two resident tables in QlikView

Accesing fields from two resident tables

Wed, 13 Nov 2013 01:21:12 GMT

HI guys,

I have this script.

[Table1]:

Load

Amount

Resident A;

[Table2]

Load *,

If (qty < 0, Table1.Amount * -1, Table1.Amount)

it complains the Table1.Amount as field not found.

I wanted to know if it is even possible to access fields from other resident table the way i am trying to do.

Regards,

Saurabh

Clever_Anjos — Wed, 13 Nov 2013 03:05:38 GMT

Is there any keys between those tables?

Check your manual for LOOKUP() function, maybe it can help you

jagan — Wed, 13 Nov 2013 03:44:41 GMT

HI,

Is there any primary key between the two tables, if yes then join the two tables and then perform the calculation.

Regards,

Jagan.