Discussion Board for collaboration on QlikView Scripting.
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.
Hi Buse, try enclosing all the Key in a Text() function:
Text(CLIENT.... TEXT(CUSTOMER)) as Custom...
Text(CLIENT.... , CUSTOMER) as Custom...
I forgot to say that i tried Text(CLIENT.... , CUSTOMER) as Custom.. formula, it didnt work.
What do you see when you just do Text(CUSTOMER) AS TextCustomer
do you see 00011 or 00000011?
please post some sample data and your relevant script part including the Customer field load to test with.