For this retail example, I am importing sales data into a Sales table, which automatically updates the Inventory table. Here’s what I want to solve for:
As file is being imported into Sales table, check productID against Inventory table to see if productID exists, if it does not, do not import.
Thanks for your help!
How are you importing the records?
Right now, by csv. I’m willing to consider other options in order to discard those unwanted rows, as long as it’s not manual!
Ok, one thing you can do is create a view where, productID is blank, and then just bulk delete those imported rows or you can remove them prior to import in excel with a macro.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.