Forum Discussion

Brass Contributor

Dec 04, 2023

Solved

PowerQuery Remove Rows dependent on value in column.

Labelling software generates a transaction report that represents each label generated, I pull data from this report using PowerQuery. Each row is an individual label or transaction. When an erro...

BI & Data Analysis

excel

Lorenzo
Dec 04, 2023
Andrew__K
Alternative:
- Group by [Serial Number]: Count Rows + (keep) All Rows
- Filter out [Count] > 1
- Combine tables (with Advanced Editor)
Andrew_K_alternative.xlsx25 KB

Riny_van_Eekelen

Platinum Contributor

Dec 04, 2023

Andrew__K I would Group (Count Rows) by Serial Number. Keep only serial numbers that have a count of 1. Then merge that table with the table from the Source step (RightOuter) and clean up a bit.

See attached file.

Andrew_K.xlsx20 KB