Using Data Shuttle to check for duplicate values

Aimee Hatcher

I am trying to have data shuttle check if something on the target sheet already exists on the file I am using in Data Shuttle.

For example, my target sheet has UPC, UOM, Vendor Name and Vendor Part number. I want to have it check the file I load into Data shuttle and return the Internal Part number if it matches those 4 data points.

I did try by concatenating those 4 cells on both the target sheet and the file loaded to data shuttle but it won't work because the column on the target sheet is a formula. I can't take the formula out of that column because new lines are added daily.

Any ideas?

kowal

hi @Aimee Hatcher,

you can create helping column in your Destination sheet call it "check if duplicates" and put the formula inside:

=IF(COUNTIF(Joined:Joined, =Joined@row ) > 1, 1, 0)

in the column joined you can add text of each column you are syncing using data Shuttle like =text@row+text2@row etc. etc.

In Data Shuttle use option to add new Data (do not replace) so if the same set of data will come from data shuttle there will be checkbox in "check for duplicates" :)

Hope it helps.