Msg.payload for vertical table

[Jhankhana]

Hello there!
Need you help.

I am receiving data and has date using function. below Is what I have written in function node to pass those value in table node. that is giving me horizontal table.

msg.payload = [
    {
        "Date": printdate,  
        "Time": printtime,
        "Machine_ID": MachineID,
        "Customer_ID":CustomerID,
        "Customer_Name":CustomerName,
        "Date_of_Instolation":Instolationdate
    },
  ];

But I want to display it in vertical table.
What should I write for that?

[Steve-Mcl]

2 options.

1. Change your database query to return that shape of data (fastest)
   OR
2. Modify your function to change the shape of the data (slowest)

---

For item 2, this should work...

msg.payload = Object.entries(msg.payload[0])
return msg