Hello all, recently i have manage to split data from MQTT and saved as CSV ,thanks to forum member that really kind and helpfull.
For now i want to do is add timestamp(if im not mistaken) which add date and time of data taken.the date and time is already stated in the MQTT and Node-red , how to refer it and add it into csv file..
i have read some example and tried but fail, the result as below:
since i have 3 change node for 3 axis for y-axis
"Y-AXIS," & $$.payload.Y-AXIS & $moment().tz("Asia/Tokyo").format(",DD/MM/YYYY,h:mm:ss a") for z-axis
"Z-AXIS," & $$.payload.Z-AXIS & $moment().tz("Asia/Tokyo").format(",DD/MM/YYYY,h:mm:ss a")
the result,(probably due to function split,,as im changing to JSON string will fix it and repost)