Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Re: Discard certain rows of data during import process

1326 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Shawn_Titus
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
Vivid-Squid
11 - Venus
11 - Venus

Hi @Shawn_Titus
How are you importing the records?

Shawn_Titus
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!

Vivid-Squid
11 - Venus
11 - Venus

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.