Sync incoming mqtt data with timestamp in an excel file(csv)

#1

I am trying to sync data coming in through mqtt with the timestamp obtained in node-red, into an excel file in the order (timestamp, tag name, sensor1,sensor2,sensors,sensor4), which I require in this exact format to be able to push this data into infuxDB. But I am getting the tag name and sensor data in one line and the timestamp in the next line. Can anyone help me out with syncing the data

#2

Not unless you give us some clues on how you are doing it. Post the bit of your flow that adds the date in with the data. And writes it to the file.

1 Like