Hi,
I am trying to combine a point in time AR data file with 6 million rows, that contains Document numbers, to a live database that contains SOME matching Accounting Doc numbers but has many more rows 57 million than the point in time database file, to try to see what items from the point in time data set have been cleared in the live database.
I want to keep all of the Point in time Document numbers (so that I can tie back to the original dataset totals), and match them with an Accounting document number from the Live database (if there is one) and if not, I still want the point in time rows, I just want the Live dataset match to come back null or all 0's, or some indicator that the point in time Document number was not found in the Live database.
Does anyone know a way to do this? Point in time Document number = Accounting Document number from Live dataset, however, when I use the join tool, the unmatching records get eliminated. I want to keep all of the Point in time records. I have read about a left/ right outer join, and I feel like that is what I want, I just cant get it to happen in my workflow.
Hopefully some of you very smart people can help!
