Data Load Editor Flagging Latest Record By Unix Time Stamp

[griffin2571]

I am trying to flag data based off the max unix timestamp. However, For some reason it isn't able to flag correctly in my script. But it just comes out as null

Vin Number	Unix Time	Car Model
*0000GF004	3291598799	BMW
*0000GF004	3422170859	BMW
*0000GF004	3266301599	BMW

Temp:
NoConcatenate
Load %PSBKey,
max(Unix Time) as Last_record
Resident Cartable
group by %PSBKey
;

Left Join (Cartable)
Load *
Resident Temp
;

Drop table Temp;

Temp1:
NoConcatenate
Load *,
if(Cartable=Last_record,'Yes') as Latest_record
Resident Cartable;

Drop table Cartable;

Rename table Temp1 to Cartable;