How to handle duplicates

[#1]

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

[ipauldur]

Hi Ale,

Hope this will help. Find the attachment.

Here, Flag is ur compnay Name

Regards,

Durai.

[#3]

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

[ipauldur]

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.