Dataset and numbers missing

Get Help
1

Hello. Got the dataset working nicely, but wanted to ask a question concerning data processing and numbers. Here you can see an example of the dataset json and the entries are read correctly to CMS. But, when you look and compare the entries and the “processed” lines, the number zeros (0) that are last, are missing?

Have I missed something when setting up my dataset or is this generated by default and cannot be changed?

Thank you for your help.

{
   "entries": [
      {
         "prices": {
            "first": "5.001",
            "second": "1.010",
            "third": "2.910"
         }
      }
   ],
   "number": 1,
   "processed": [
      [
         {
            "detail": "first",
            "price": 5.001
         },
         {
            "detail": "second",
            "price": 1.01
         },
         {
            "detail": "third",
            "price": 2.91
         }
      ]
   ],
   "messages": [
      "Processing 1 results into 2 potential columns",
      "Processing Result with Data Root prices",
      "DataRoot is an object",
      "Processing as Multiple Rows",
      "Processing first",
      "Processing second",
      "Processing third",
      "Consolidating entries",
      "There are 3 entries in total"
   ]
}
2

The trailing zeros are being removed because they’re not significant.

If you want to display a number with a specific number of trailing zeros, then you can setup a formula column to take the imported numbers and convert them to the format you need, or import those numbers as text, and then they won’t be adjusted.

3

Hi Alex!
Yes, I thought this might be the case. I will try this way to display the numbers.
Thank you for your message!