topic Matching data that does not match entirely in QlikView

Matching data that does not match entirely

Tue, 28 Dec 2010 13:32:19 GMT

I want to create a report where I reflect the details from Table 1 & Table 2. I have two tables that reflect the same data but with a slight variation. In the Table 1, the persons name appears as first name, and surname as individual fields. In Table 2, the same person will appear as the the first name and surname combined however limited to 29 or 30 characters. How would I match the data correctly or link it together so that the same person may exist as one record in a report.

Example:

Table 1

First name: Barry Roland James Porter Ta

Surname: Anastasia

Table 2:

Agent: Barry Roland James Porter Ta A

Matching data that does not match entirely

ashfaq_haseeb — Tue, 28 Dec 2010 13:36:04 GMT

hi musta

concat two fields in table1

Load

First name & left(Surname,1) as Agent

fom xxx

Regards

Ashfaq

Matching data that does not match entirely

syed_muzammil — Tue, 28 Dec 2010 13:38:00 GMT

Hi,

Create another field in you Table 1 which has Firstname and surname Concatenated and upto 25 or 30 (depending on the size of your Agent Field)characters. Eg:

Tab1:

Load

First Name,

Surname,

Left(Firstname&Surname,25) as Agent

Tab2:

Load

Agent