Tableau json format

Question

在Tableau Public的文档中，人们可以读到：

单个 JSON 对象不能超过 128 MB。

当单个对象顶级数组超过 128 MB 时，必须转换 它到一个文件，其中每行定义一个 JSON 对象。

尝试加载 (95 MB！JSON 文件放入 Tableau，我收到一个错误：

Tableau 在 JSON 中遇到大于 128 MB 的单个对象 文件。请使用较小的 JSON 文件重试。

我的文件是一个格式的大型数组：

[
  {"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"}
...
]

如何让 Tableau 接受此文件？

Answer 1

好吧，您基本上必须按照帮助文本的规定进行操作。每行一个 JSON 对象。而已。我试过了，但我忘了删除每行末尾的逗号 (，(。

您的文件应如下所示：

{"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"}