Vlookup but to multiple data fields?

[jason414]

Hi all,

I'm new to qlik. I have 2 large tables. I want to link data from 1 table to the other without expanding the dataset and slowing down my app.

Ex:

Table 1: ID, Value

Table 2: Date, ID2, Value2

I want to have ID and Value in my app and then I want an interactive graph where if I select ID in Table 1, it will show a graph of Date and Value2.

Ultimately: How can I create a link between ID and ID2 such that I'm not performing a join/merge? I've tried lookup but this seems to only work if there's 1 unique value ID-ID2 (in this case won't work since there can be multiple due to the Date field in Table 2).

[PrashantSangle]

If you don't want to do join or Merge then use Qlik's Golden feature "Data Association"

Keep the same name of both field. In your case alise ID2 as ID.

If it won't work for you then explain your query with sample data??

Regards,

Prashant Sangle

[Padma123]

table1:
load * inline [
id,value
1,100
2,200
3,900
];

table2:
load *,Lookup('value','id',id,'table1') as lookup;
load date,id2 as id,value2;
load * Inline [
date,id2,value2
1/1/2025,1,900
2/1/2025,3,700
3/1/2025,2,400
1/3/2025,2,900
];

[Chanty4u]

Create a bridge table 

Table1:

LOAD

    ID,

    Value

FROM Source1;

Table2:

LOAD

    Date,

    ID2,

    Value2

FROM Source2;

.

BridgeTable:

LOAD DISTINCT

    ID AS CommonID,

    ID2 AS CommonID

RESIDENT Table2;