griffin2571
Contributor
2023-03-14
09:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Load Editor Flagging Latest Record By Unix Time Stamp
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;
Labels (7)
Labels
- Subscribe by Topic:
-
Data Load Editor
-
Developers
-
expression
-
filter
-
General Question
-
Script
-
Variables
344 Views
0 Replies