Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Key dublicate

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.

Ekran Alıntısı.PNG

Ekran Alıntısı1.PNG

4 Replies
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...

Not applicable
Author

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