Unnest

Learn how to use the Unnest transformation to convert delimited values into separate rows and flatten your data.

Using the Unnest transformation to flatten your data

You can leverage the Unnest transformation to flatten your data. For instance, when you have multi-select options or comma-separated text values in your report, you can split your values into multiple rows.

Let's look at an example to demonstrate how the Unnest function works. Consider a table that captures the orders placed. The investment products purchased by each customer are separated by commas.

Orders table

An account manager may need to add details specific to each investment instrument, like an interest rate. They would need each product in a separate row to enter the rates as shown below. This is where the Unnest function can be used.

Flattened data

Let's look at this Inforiver report that contains a multi-select data input field with benchmarks.

Inforiver report with multi-select options

After importing the report into Infobridge and removing the Quarter column, let's apply the Unnest transformation. Choose Benchmark as the target column and comma as the delimiter.

Unnest transformation in Infobridge

Notice how each benchmark is flattened into a separate row. You can perform operations like creating a conditional column to set a rate for each benchmark.

Output of Unnest transformation