Want to find Max.

[Sxbbb]

Want to find Max of Type = CU IN HOLE DIF

[Sxbbb]

I don't understand, I just want  an expression 

[BrunPierre]

Can you share a sample data/app?

[Sxbbb]

That is, I need to find the Max value of each Type, each Id. Now I'm looking for the max value of Type =CU IN HOLE DIF.

This is all information. There are two ID in this data set

I want result Type   CU IN HOLE DIF = 42.61 and 40.29 

because there are two ID .

If it's Type CU ON SURFACE DIF, get max = 61.30 and 52.70

Do you understand?

[BrunPierre]

What about CU_BoardNo 1, 3, 4, 6 and 8, they equally have two IDs?

[Sxbbb]

Yes, but I'm only interested in the ID of each data set, I don't care how many Board No.

[BrunPierre]

Script

Temp:
LOAD * Inline[
CU_TypeHole,CU_BoardNo,CU_HoleMax,CU_Symbol,FA_ID
CU IN HOLE DIF,1,36.67,0.00,281F
CU IN HOLE DIF,1,40.33,0.00,1D22
CU IN HOLE DIF,2,40.29,0.00,281F
CU IN HOLE DIF,2,40.44,0.00,1D22
CU IN HOLE DIF,5,37.38,0.00,281F
CU IN HOLE DIF,5,42.61,0.00,1D22
CU IN HOLE DIF,8,36.25,0.00,281F
CU IN HOLE DIF,8,40.26,0.00,1D22
CU ON SURFACE DIF,1,36.67,0.00,281F
CU ON SURFACE DIF,1,40.33,0.00,1D22
CU ON SURFACE DIF,2,40.29,0.00,281F
CU ON SURFACE DIF,2,40.44,0.00,1D22
CU ON SURFACE DIF,5,37.38,0.00,281F
CU ON SURFACE DIF,5,42.61,0.00,1D22
CU ON SURFACE DIF,8,36.25,0.00,281F
CU ON SURFACE DIF,8,40.26,0.00,1D22
];

NoConcatenate
LOAD CU_TypeHole,
     CU_BoardNo,
     CU_Symbol,
LastValue(CU_HoleMax) as CU_HoleMax,
LastValue(FA_ID) as FA_ID

Resident Temp
Where CU_TypeHole = 'CU ON SURFACE DIF'
Group By CU_TypeHole, CU_BoardNo, CU_Symbol;

DROP Table Temp;

EXIT SCRIPT;

Output