topic Left Join - Max value with master table in Connectivity & Data Prep

Left Join - Max value with master table

kppiee — Fri, 10 Dec 2021 21:09:00 GMT

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

Table 1:

Table 2:

Result:

JuanGerardo — Wed, 28 Apr 2021 15:11:54 GMT

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;