9. Data transformations

Transform your data within Infobridge - add dimensions and measures, pivot columns, sort, filter, and format your data. Perform all these operations without modifying your source visual.

Let's explore the transformations available in Infobridge.

TRANSFORMATION	DESCRIPTION
Pivot table	Restructure your dimensions and measures to align with the target report.
Group by	Summarize and aggregate your detailed data for crisp high-level reports.
Add column	Add calculated measures and custom dimensions.
Pivot column	Convert row values from one column into multiple columns.
Unnest	Flatten your comma-separated data into multiple rows.
Rename column	Change the name of any dimension or measure.
Find and replace	Search for a string or value and replace it with another.
Remove measure	Remove selected measures from the query.
Filter rows	Remove redundant rows that do not match the specified filter condition.
Sort	Apply a custom sort order for measures and dimensions.
Text functions	Extract and format text data.
Unnest	Convert delimited values into separate rows and flatten your data.
Round	Round numeric data to a specified number of decimal places.
Extract Comments	Extract cell-level comments from the source report into a separate column.
Import and export	Export and download transformation steps and import them into another query to re-apply the same steps.