Column-Wise Array Expansion
MongoDB’s BSON document structure can store array data types. To interpret that data, the user must decide how they want those multi-value fields to be displayed.
Column-wise array expansion takes an array of values and expands them into multiple table columns creating several columns equal to an array specific number set by the user. If there are multiple column-expanded arrays in the same document, the combined number of new columns is appended to the end of the table with their respective array
indices and the original columns are removed.
To use the column-wise expansion feature, select Column-Expanded Array in the Structure drop-down box.
The corresponding Column Count text box will be enabled, and the user can enter the number of columns for the plugin to generate as columns for that array.
(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.