Pivoting

Pivot

When setting a connector to ingest nested data as pivot data in subtable, Panoply will transform the object or JSON string into an array of objects with two fields in each object (key & value). This will pivot the fields in the original object into rows in the end-tables.

For example, the following record contains a nested location object:

{id:1, location: {city: 'San Francisco', state: 'CA', country: 'USA'}}

When setting the location as pivoting into subtable, it would be ingested into the location subtable in the following format:

Note that pivoting the nested data is applicable for nested objects only, not for nested lists.

The nested data behavior exists directly in the data sources. Enter specific field paths and set their nested behavior to pivot data in subtable.