Forum Discussion
Duplication of values/rows when parsing a JSON
Hello everyboy, I really hope you can help with this issue that's giving me headache! I'm importing from MySQL several tables with 3 columns: - id - json - timestamp I transform the JSO...
Can you check your json to see if related objects are included? Related objects are included in the example below. The table in the selected cell contains all values from the current row, which can be seen in the preview section. If all columns, including the related objects, were expanded, the values would be duplicated. Note, the example is a snip of SQL table - I didn't have a JSON example handy, but the theory is the same. To fix this, you would need to either omit related objects from the json, or only expand non-related objects.
This page has information about json and related objects.