Max of another dimension of every single value loaded

[Anonymous]

<simple question>

I am loading data from various tables.

I have 2 tables which are associated through Contact name.

Customer name	Contact name
A	Peter
A	Mike
A	John
B	Paula
C	Paul

Contact name	Score
Peter	80
Mike	100
John	120
Paul	10
Paula	10

When I select this data I would like to create a Max Score for every Customer name.

Any clue/hints is highly suggested?

Customer name	Max Score
A	120
B	10
C	10

</simple question>

[antoniotiman]

Hi Omar,

Temp:
LOAD [Customer name],[Contact name]
FROM "https://community.qlik.com/message/1313701"
(html, codepage is 1252, embedded labels, table is @1);
Left Join LOAD [Contact name],Score
FROM "https://community.qlik.com/message/1313701"
(html, codepage is 1252, embedded labels, table is @2);
LOAD [Customer name],Max(Score) as Score
Resident Temp Group By [Customer name];
Drop Table Temp;

Regards,

Antonio