I'm currently dealing with nested JSON data that I need to flatten for easy display in a table format, without using dropdowns.
The structure of the data is somewhat similar to this...
0:
ID: 4
Date: "2019-08-09T00:00:00"
Data:
Year: 2019
Identification: "F31073"
nestedArray: Array(1)
0:
array1ID: "31"
array1Code: "073"
nestedArray2: Array(4)
0:
array2info: 24
nestedArray3: Array(8)
0:
array3Identifier: "ECF5EE44-50E1-4F07-AB38-CF7A60A6276F"
array3Number: 31
arrayThreeIndicator: "N"
nestedArray4: Array(1)
0:
array4Info: "31"
array4Code: "073"
I've explored various solutions but none have provided me with a flat dataset.
UPDATE: Below is the JSON data that I am looking to flatten, ensuring that all fields from each nested array are duplicated and visible without any nesting:
"[{"FileCustomerIdentifier":4,"TransmissionDate":"2019-08-
09T00:00:00","TransmissionData":"{\r\n \"cropYear\": 2019,\r\n
\"originatorIdentification\": \"F31073\",\r\n \"farm\": [\r\n {\r\n
\"administrativeStateFsaCode\": \"31\",\r\n
\"administrativeCountyFsaCode\": \"073\",\r\n \"farmNumber\":
4609,\r\n
\"tract\": [\r\n {\r\n \"tractNumber\": 24,\r\n
\"field\": [\r\n {\r\n \"cluIdentifier\":
\"ECF5EE44-50E1-4F07-AB38-CF7A60A6276F\",\r\n
\"fieldNumber\":
31,\r\n \"cluProducerReviewRequestIndicator\": \"N\",\r\n
\"agriculturalProductionPlan\": [\r\n {\r\n
\"stateAnsiCode\": \"31\",\r\n \"countyAnsiCode\":
\"073\",\r\n \"coreProductCode\": \"0102\",\r\n
\"coreProductTypeCode\": \"0794\",\r\n
\"productIntendedUseCode\": \"0007\",\r\n
\"originalReportedAcreage\": 109.93,\r\n
...
"
Any assistance on this matter would be highly appreciated!