Tableau JSON格式

Question

在Tableau Public的文档中，可以看到：

一个单独的JSON对象大小不能超过128MB。

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

当我尝试将一个（95 MB！）JSON文件加载到Tableau中时，我遇到了错误：

Tableau在JSON文件中遇到一个大于128MB的单个对象。请尝试使用较小的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接受这个文件？

- Fontanka16

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

- Fontanka16