Import Issue with JSON File and DashesI 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?
I attached one of the files that is causing issues and also my basic file import.
Data TableScriptingRe: Import Issue with JSON File and DashesI 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,
TSRe: Import Issue with JSON File and DashesThat makes sense that it is pulling the value in as a date and that is messing things up. How do I force the column to come in as a text instead of as a date?
