15.12.6 Flattening Vector Properties

You can split the vector properties into multiple columns using the flattenAll() operation.

For example, you can flatten the vector properties for the example explained in Loading and Storing Vector Properties as shown:

Flattening Vector Properties Using JShell

opg4j> vecFrame.flattenAll();

Flattening Vector Properties Using Java

vecFrame.flattenAll();

The resulting flattened PgxFrame may appear as shown:

+----------------------------------------------------------------------------------------------------+
| intProp | intProp2 | vectProp_0 | vectProp_1 | vectProp_2 | stringProp | vectProp2_0 | vectProp2_1 |
+----------------------------------------------------------------------------------------------------+
| 0       | 2        | 0.1        | 0.2        | 0.3        | testProp0  | 0.1         | 0.2         |
| 1       | 1        | 0.1        | 0.2        | 0.3        | testProp10 | 0.1         | 0.2         |
| 1       | 2        | 0.1        | 0.2        | 0.3        | testProp20 | 0.1         | 0.2         |
| 2       | 3        | 0.1        | 0.2        | 0.3        | testProp30 | 0.1         | 0.2         |
| 3       | 1        | 0.1        | 0.2        | 0.3        | testProp40 | 0.1         | 0.2         |
+----------------------------------------------------------------------------------------------------+