mradamlacey / elasticsearch-tableau-connector

Tableau Web Data Connector for Elasticsearch
MIT License
149 stars 64 forks source link

Support for array types #37

Open Jestar342 opened 7 years ago

Jestar342 commented 7 years ago

I know the readme says these are ignored, but I figure this isn't desirable and I didn't see an existing issue for it, so here we are :)

mradamlacey commented 7 years ago

Could you provide any more details of what you think the expected behavior should be for array types? How would you expect those to show up in Tableau (and what Tableau data type should they be mapped to?)

maximeloizeau commented 7 years ago

For a custom need that we have, we decided that if we have an array of strings in ES, we squash it into a comma-delimited string. I don't know if this would be generic enough to be useful to someone else but it could be a first idea about this.

https://github.com/maximeloizeau/elasticsearch-tableau-connector/commit/01ec3e9145531df8a54fc1748416dc867c716afe

chuchurocket27 commented 7 years ago

Based on how the JSON connector works in Tableau, you could make duplicate records, one for each element of the array. See https://onlinehelp.tableau.com/current/pro/desktop/en-us/examples_json.html