topic Re: Key dublicate in QlikView

Key dublicate

Fri, 18 Nov 2016 13:37:55 GMT

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 — Fri, 18 Nov 2016 13:48:06 GMT

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

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

or just:

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

Fri, 18 Nov 2016 13:57:05 GMT

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

sunny_talwar — Fri, 18 Nov 2016 15:58:07 GMT

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

do you see 00011 or 00000011?

MarcoWedel — Fri, 18 Nov 2016 18:31:03 GMT

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

thanks

regards

Marco