How To Avoid Duplicates in Dataport

Business Central/NAV User Forum
1

Hi ,

Is there any way to avoid Duplicates while Importing Data(DataPort) other than Primary Key,

IF so any sample code or any method

please help me out…

2

Hello,

as a first I idea i would use a tmp TABLE inserting the whole input file then looping through the TMP table retriving only the unique row, finally insert into the destination.

Maybe this a quick and dirty solution but I’m pretty sure that should works,

Bye

3

Hi

I Already Have Duplicates in my Table,My Client Dont Want any more duplicate Data from now, They need an error alert While Importing Data.

4

Or is there any way to avoid duplicates in table