Transforming data

Building challenge

With your inventory data combined, calculate discrepancies, flag which SKUs are out of sync, and sort the results so discrepancies appear first. Copy and paste this prompt into Parabola:

First, calculate a new column called "Inventory Discrepancy" by subtracting "Shopify Quantity" from "NetSuite Quantity".

Then add a column called "Discrepancy Status":
- If "Inventory Discrepancy" equals 0, set it to "✅ No Discrepancy"
- Otherwise, set it to "❌ Discrepancy"

Then sort the data so that rows where "Discrepancy Status" is "❌ Discrepancy" appear at the top.

Finally, filter out any rows where "SKU" contains the word "RETIRED".

Overview

Building fundamentals

Transforming data

Building challenge