Skip to main content
DD-TRF-003 Complex Joins, Exceptions and Transformation Logic Get the data →
DD-TRF-003-Q029 Medium Time series

Drifted columns per batch file

For each batch file, count the columns that are renamed, missing or extra against the first file. Which file drifts most?
Expected
One row per batch: file, drifted columns · Bar chart
Tables
Batch_2025_07, Batch_2025_08, Batch_2025_09, Batch_2025_10 +2 · columns
  • Batch_2025_07
  • Batch_2025_08
  • Batch_2025_09
  • Batch_2025_10
  • Batch_2025_11
  • Batch_2025_12
  • TransactionID
Topics
Data Quality

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in