> ## Documentation Index
> Fetch the complete documentation index at: https://parabola.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# How to compare columns between two datasets in Parabola

> Need to compare two datasets to see which columns are the same and which are missing from either one? Follow these steps to quickly identify overlapping or missing columns using Parabola.

## ✅ Step-by-Step Instructions

<Steps>
  <Step title="Import both datasets">
    Bring in the two datasets you want to compare using two data import steps.
  </Step>

  <Step title="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.
  </Step>

  <Step title="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`
  </Step>

  <Step title="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
  </Step>

  <Step title="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
  </Step>

  <Step title="Review the results">
    The output will show:

    * Which columns are shared between the two datasets
    * Which columns are missing from either one
  </Step>
</Steps>

## 🧠 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!

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/_Rd06MegMqgoEJ3a/images/article/image-2.png?fit=max&auto=format&n=_Rd06MegMqgoEJ3a&q=85&s=f34948b1d3bcef87ac530f9ffc0e0ad0" alt="" width="2452" height="1644" data-path="images/article/image-2.png" />
</Frame>
