Key dublicate

[#1]

Hi community,

I have a question about dublicate rows.

As you can see the customer numbers are different but CustomerKey is same.

I load the data with using text() functions but I dont know where did I do wrong?

Thanks for help.

[rubenmarin]

Hi Buse, try enclosing all the Key in a Text() function:

Text(CLIENT.... TEXT(CUSTOMER)) as Custom...

or just:

Text(CLIENT.... , CUSTOMER) as Custom...

[#3]

I forgot to say that i tried Text(CLIENT.... , CUSTOMER) as Custom.. formula, it didnt work.

[sunny_talwar]

What do you see when you just do Text(CUSTOMER) AS TextCustomer

do you see 00011 or 00000011?

[MarcoWedel]

please post some sample data and your relevant script part including the Customer field load to test with.

thanks

regards

Marco