Skip to main content
DD-TRF-002 Multi-File Transformation and Data Quality Get the data →
DD-TRF-002-Q036 Medium Time series

Export rows absent from each batch

Collapse duplicates in the export (one row per TransactionID, before any other cleaning). For the period each batch file covers, how many export TransactionIDs are missing from the batch? Which batch misses most?
Expected
One row per batch: file, missing rows · Bar chart
Tables
FactRawEvents, Batch_2025_Q1, Batch_2025_Q2, Batch_2025_Q3 +1 · columns
  • FactRawEvents
  • Batch_2025_Q1
  • Batch_2025_Q2
  • Batch_2025_Q3
  • Batch_2025_Q4
  • TransactionID
  • TransactionDate

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