mosql
mosql copied to clipboard
mongo array support
Maybe i missed this from documentation, Is it possible to extract data from an array ?
ie :
mongodb:
collection:
:columns:
- latitude:
:source: location[0]
:type: FLOAT
- longitude:
:source: location[1]
:type: FLOAT
Same Issue. Will the above stuff work?
Did you test this?
@arnists excuse me for the delay.
i tested it and i have got a [null]
instead of the content
hi, any thoughts on this issue. Our mongo structure is full of array. It's really hard to parse jason array in tableau
@JosephZeng1121 AFA in my case, we ditched Tableau and used Pentaho through KTR files. Pentaho is not that visually appealing as of Tableau, but it is versatile enough and helped us to get our work done.
@JosephZeng1121 a way could be to update the code and add the support for arrays.
I had a look at it, and I think what should be changed is after this line
and at schema.transform(...)
method.
Can this help?