This is the first time I've worked with a JSON file, so please bear with me. I'm trying to load a JSON file from the EIA that has a data array with two elements, a date stored as a text and a decimal number as the value. However when I load the data into Tableau it reads the date string fine but loads the number as a null. When I changed the date string to a number it seemed to load fine but then loads the strings as nulls. Can I not mix data types in the same array?
It's unusual to mix types in an array in JSON, but it's legal JSON. However, Tableau can't handle it.