Forum Discussion
Solved
Identify offsetting entries based on multiple criteria
Hi there. I have a data set in which a subset are opposing entries but to different "customers" (example data below). I need to identify in my data set which rows have the following criteria: Custo...
Thanks Dinesh. I've been pulled in a few different directions so won't be able to finalize for another week or so. Happy to mark it as done given I should be able to sort something and appreciate the support everyones provided.
- Read about Table.Buffer for better overall performance
- Read about Table.AddKey to speed up merges
- Generally, try to avoid merges as much as possible, let the data model do the work instead (in memory!)