...
Code Block |
---|
#PARSER PQL #ADDQUERY in = CSVFILESOURCE({ schema = [ ['date', 'STRING'], ['station_uuid','STRING'], ['diesel','FLOAT'], ['e5','FLOAT'], ['e10','FLOAT'], ['dieselchange','BOOLEAN'], ['e5change','BOOLEAN'], ['e10change','BOOLEAN'] ], READFIRSTLINE = false, filename = 'D:/tankerkoenig-data/prices/2023/01/2023-01-01-prices.csv', source = 'Tanker-2023-01-01' } ) /// Java seemsE.g. if you want to haveremove problems+01 with:from 2023-01-01 00:00:10+01 yyyy-MM-DD HH:mm:ssZ tsCorrected = TIMESTAMP({START = 'toTimestamp(substring(date,0,19),"yyyy-MM-DDdd HH:mm:ss")'}, in) |