Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kppiee
Contributor II
Contributor II

Left Join - Max value with master table

Need to left join table 2 to table 1 with showing value of Max(Type)

 

Table 1:

IDName
1A
2B
3C

Table 2:

IDTypeValue
12550
12660
12770
12850
12940
22556
22667
22746
22845
22923
32535
32646
32745
32887
32990

Result:

IDNameValueType
1A4029
2B2329
3C9029
Labels (1)
  • Other

1 Reply
JuanGerardo
Partner
Partner

Hi @kppiee , I think you can use a double join with value and type, something like:

Load

   ID,

   Name

Resident Table1;

Left Join

Load

   ID,

   Max(Value) AS Value

Resident Table2

Group By ID;

Left Join

Load

   ID,

   Value,

   Type

Resident Table2;

 

JG