Skip to main content

​
✅ Step-by-Step Instructions

1

Import both datasets

Bring in the two datasets you want to compare using two data import steps.
2

Limit to 1 row of data

Add a limit Rows step to each dataset to limit them to just 1 row. You only need the column names and 1 row of data for this comparison.
3

Tag each dataset

Add an Add Text Column step to each dataset.
  • Create a new column called something like type
  • Assign a unique value to each: e.g., Dataset 1 and Dataset 2
4

Unpivot the columns

Use an Unpivot Columns step on each dataset.
  • Unpivot all columns except the new type column
  • This transforms column headers into row values
5

Combine the datasets

Use a Combine tables step:
  • Match on the column name from each unpivoted dataset
  • Keep all rows to include matches and differences
6

Review the results

The output will show:
  • Which columns are shared between the two datasets
  • Which columns are missing from either one

​
🧠 Why This Works

By unpivoting and tagging each dataset, you convert column headers into values, which makes it easy to compare structure across datasets using Parabola’s visual tools—no code needed. Let us know if you want a template for this setup!
Last modified on February 26, 2026