Discard certain rows of data during import process

[Shawn_Titus]

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!

[Vivid-Squid]

Hi @Shawn_Titus
How are you importing the records?

[Shawn_Titus]

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!

[Vivid-Squid]

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.