Forum Discussion
Removing duplicate rows, data from different (joined) data sources
...or I have to build a named TABLE out of at least three database joins, filter it down and then jump over to the report view to finish the summary. Parking it for tonight - shouldn't be doing work today anyway 🙂
I've put a data sample ino three sheets in an Excel workbook. Task is to join FreeTextInvoiceHeaders to FreeTextOrderLines using the InvoiceIdentifer as the join, then to CustAgedBalances using Account Number as the join. Find all InvoiceLines with "HE Subs" or "FE Subs" in the InvoiceText, List all the Invoices and their values, then disregard all lines where the Amount Outstanding is less that then invoice value (ie: looks like they've paid).
You'll end up with a handful of customers with two different invoices list; I want to be left with just the latest date one for each customer.
Now, where do I place my Excel workbook?