topic How to handle duplicates in QlikView

How to handle duplicates

Wed, 26 Aug 2009 18:46:59 GMT

Hi Qlik beginner is Ales here 🙂

I have probably very simple beginners problem. Even thou I went through some other posts around, I was not able to find answers on my problem.

I have two table from different sources. These tables are about emplyess in two companies. Company A and company B. Unfortunately employee number doesn't have same format. In company A it is 3 digits and in company B 4 digits (both starting with zeros).

What is the most elegant way sort this problem out?

I was thinking if, there is any command, I can use in the script to create another filed with Company mark in Company A and Company B load? But then I might have still problem with same (duplicate) employee numbers and also different amount of digits... So can I somehow merge Company mark (A) with emplyee number? (like A-0001)

I am including this very simple example.

thank you for help

Ales

How to handle duplicates

ipauldur — Wed, 26 Aug 2009 18:57:54 GMT

Hi Ale,

Hope this will help. Find the attachment.

Here, Flag is ur compnay Name

Regards,

Durai.

How to handle duplicates

Thu, 27 Aug 2009 14:50:47 GMT

Hi Durai,

thanks for answer, but I was probably not very clear. I don't have in my database the flag A and B. I would like to somehow manualy add this flag in there.

thank you

Ales

How to handle duplicates

ipauldur — Thu, 27 Aug 2009 14:55:12 GMT

Hi,

Yes, you can add in your load statement.

For example,If you are taking data from two tables for two companies,then say,

'A' as company in the first table and 'B' as company in the second table.

Regards,

Durai.