1 Reply Latest reply on Oct 10, 2018 2:01 PM by Dan Cory

    JSON Issues with Data Arrays with Mixed Data Types

    ben cho



      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?