Discard certain rows of data during import process

Topic Labels: ImportingExporting
768 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

3 Replies 3

Hi @Shawn_Titus
How are you importing the records?

5 - Automation Enthusiast
5 - Automation Enthusiast

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.