Flattening Vector Properties

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

opg4j> vecFrame.flattenAll()

vecFrame.flattenAll();

vec_frame.flatten_all()

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         |
+----------------------------------------------------------------------------------------------------+

Parent topic: PgxFrames Tabular Data-Structure