elasticsearch-tableau-connector icon indicating copy to clipboard operation
elasticsearch-tableau-connector copied to clipboard

Support for array types

Open Jestar342 opened this issue 7 years ago • 3 comments

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 :)

Jestar342 avatar Nov 17 '16 10:11 Jestar342

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?)

mradamlacey avatar Dec 28 '16 20:12 mradamlacey

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

maximeloizeau avatar Jul 07 '17 11:07 maximeloizeau

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

chuchurocket27 avatar Oct 15 '17 23:10 chuchurocket27