nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

324335_en-US

liliconcom

Import Issue with JSON File and Dashes

I am importing data from JSON files. I have inconsistently entered data for some columns. When I import it, at times it seems to not process the information correctly.

In the case below at row 928 in column 9, the data went from a value that was entered as "2-5" to the large number that seems to have no connection to the entered value. Can someone help me understand what I need to change about my import settings?

Import Error.JPG

I attached one of the files that is causing issues and also my basic file import.

Data Table

Scripting

Re: Import Issue with JSON File and Dashes

I don't know if it helps but your large values like a date expressed as a decimal (i.e. 2-5 = February 5th). You may want to force column 9 as a text and then peel out the values with text functions.
Best,
TS

Comments

There are no comments yet