Discard certain rows of data during import process

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!

Hi @Shawn_Titus
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.

If you are comfortable with javascript you can review the scripting block input.fileAsync where you can scrub the file before adding the records.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.