not load duplicate data

[Anonymous]

Hi,

I only want to load dubble data once.

Is there a formula I can put in the load script?

Thx

[Digvijay_Singh]

You can use distinct in the load statement!

[Anonymous]

hello Digvijay,

column 'etikettnr' contains still the same double data.

[Anonymous]

Tack a Where not exists ( [etikettnr] ) onto the end of your load statement.

[Anonymous]

hello Bill,

now he shows me non of the double's and I still want to see one record  of them.

grtz