How do I want to map with Table 1 and 2

[Chinnu3]

Hi All,

I want to map the 2 tables

In result i want to see this

Thanks in advance.

[Mohan_hitman]

table1:
Mapping
Load
table_name,

salary

from table1;

table2:

load 

id,

name,

sales,

Applymap('table1',salary,'Un Defined') as sal,

from table2;

[Chinnu3]

Hi Mohan,

Table 1 has 'Name' column but Table 2 has 'Full Name' column and fields also not matching perfectly.

Could you please share a QVF files if u run the script in ur qlik?

[Mohan_hitman]

is there any common filed betwen the tables

[Chinnu3]

No, It has only 1st name is common in the 'Name' Column.

[Bhuvi]

Hii,

Try doing this,

In Table2 alias(change) the field Full Name to Name and then try to map the two tables

[Mohan_hitman]

chiinu 3 try this

[Chinnu3]

Hi,

If I change only alias name, it will match column name but the fields will not match, because it has only first name matching and other table has full name. please let me know if you do anything  and share that qvf files

thank you.

[Bhuvi · Accepted solution]

Hii,

table1:

Mapping load

SubField(Full Name,' ') as Name,

Salary

from table1;

table2:

ID,

Name,

Sales,

ApplyMap('table1',Name,'Null') as Salary

from table2;

[Chinnu3]

It's not working.