Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to map the 2 tables
In result i want to see this
Thanks in advance.
Hii,
table1:
Mapping load
SubField(Full Name,' ') as Name,
Salary
from table1;
table2:
ID,
Name,
Sales,
ApplyMap('table1',Name,'Null') as Salary
from table2;
SubField(Full Name,' ',1) as Name
Give one space between the quotes
Its working for me
table1:
Mapping
Load
table_name,
salary
from table1;
table2:
load
id,
name,
sales,
Applymap('table1',salary,'Un Defined') as sal,
from table2;
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?
No, It has only 1st name is common in the 'Name' Column.
Hii,
Try doing this,
In Table2 alias(change) the field Full Name to Name and then try to map the two tables
chiinu 3 try this
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.
Hii,
table1:
Mapping load
SubField(Full Name,' ') as Name,
Salary
from table1;
table2:
ID,
Name,
Sales,
ApplyMap('table1',Name,'Null') as Salary
from table2;
It's not working.