0 votes
1 view
in BI by (16.3k points)

In Tableau Public's documentation, one can read that

A single JSON object cannot exceed 128 MB.

When a single object top-level array exceeds 128 MB, you must convert it to a file where the JSON objects are defined one per line

When trying to load a (95 MB!) JSON file into Tableau, I get an error: 

Tableau encountered a single object larger than 128 MB in the JSON file. Please try again with a smaller JSON file.

[

  {"id":"1389406","updatedDate":"2018-01-31T10:17:31Z","createdDate":"2018-01-31T10:17:31Z","deleted":false,"Ids":["2466958"],"location":{"code":"bibd","name":"Main Library"},"status":{"code":"-","display":"AVAILABLE"},"barcode":"blah blah","callNumber":"TS","itemType":"In-house loan"},

  {"id":"1389406","updatedDate":"2018-01-31T10:17:31Z","createdDate":"2018-01-31T10:17:31Z","deleted":false,"Ids":["2466958"],"location":{"code":"bibd","name":"Main Library"},"status":{"code":"-","display":"AVAILABLE"},"barcode":"blah blah","callNumber":"TS","itemType":"In-house loan"}

...

What could I do to make Tableau accept this file?

1 Answer

0 votes
by (43.4k points)
  • Basically you have to do it with the help of text stipulates. One JSON object per line. Nothing more. I tried just that, but I forgot to remove the comma (,) I had at the end of every line.

  • Your file should look like this:

{"id":"1389406","updatedDate":"2018-01-31T10:17:31Z","createdDate":"2018-01-31T10:17:31Z","deleted":false,"Ids":["2466958"],"location":{"code":"bibd","name":"Main Library"},"status":{"code":"-","display":"AVAILABLE"},"barcode":"blah blah","callNumber":"TS","itemType":"In-house loan"}

{"id":"1389406","updatedDate":"2018-01-31T10:17:31Z","createdDate":"2018-01-31T10:17:31Z","deleted":false,"Ids":["2466958"],"location":{"code":"bibd","name":"Main Library"},"status":{"code":"-","display":"AVAILABLE"},"barcode":"blah blah","callNumber":"TS","itemType":"In-house loan"} 

Related questions

0 votes
0 answers
0 votes
0 answers
0 votes
1 answer
0 votes
1 answer
asked Nov 3, 2019 in BI by Vaibhav Ameta (16.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...