book
Article ID: KB0072268
calendar_today
Updated On:
Description
When creating a TDV mongodb connection with "flatten object" and "flatten array", the nested elements are still not flattened.
We can see sub-columns for object type but not for array even after selecting the flatten object and flatten array.
The below suggestion will be helpful.
Resolution
- Follow the reference article to set the parameters to use "flatten object" in MongoDB data source.
- Now, set the 'FlattenArrays' value to -1 in your data source configuration and save the changes made.
- Delete the previously introspected tables, and introspect again.
The value "-1" here would flatten all the elements of the nested array of objects,
Issue/Introduction
How to resolve the issue of flatten object not able to flat all the elements in TIBCO Data Virtualization(TDV) MongoDB data source.