+3For 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!
+3Right now, by csv. I’m willing to consider other options in order to discard those unwanted rows, as long as it’s not manual!
+16Ok, 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.
If you are comfortable with javascript you can review the scripting block input.fileAsync where you can scrub the file before adding the records.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.