We’ve introduced three new formulas in Dataset Transformations to help you clean, standardize, and reuse your data more efficiently:

🧩 Clean JSON or list data in one step

From [{"first_name":"Mark","last_name":"Roberts"}] to Mark

You can now extract specific values from JSON objects or lists stored in a column. No complex workarounds, string manipulation, or external preprocessing required.

👉 Learn more about how to use EXTRACT_FROM_OBJECT

🔤 Convert text to upper or lower case

From mark roberts to MARK ROBERTS

Quickly convert any text field to uppercase or lowercase. Perfect for cleaning IDs, aligning formats across systems, and ensuring consistent comparisons and VLOOKUPs across your datasets.

👉 Learn more about how to use UPPER and LOWER