Discussion board where members can get started with QlikView.
I have two tables in below format
Load * Inline
SR No,Name, City
[ No,Full Name, Occupation,salary per month
How to join these two tables as you can see common key name is diffrent in both tables, Name and fullname.
I don't want to rename my field of Full Name to Name.
In sqls against any relational data base we can compare two columns irrespective of their column name. Is it possible in QLikview?
The fields must be named the same in order to link them.
To get around the renaming, you could just load one column twice.
Inner Join (TableB)
[Full Name] as Name
This will keep FullName named as it is in TableB, but it will also add a new field to TableB named Name that will link to TableA.
I will suggest using MAP or ApplyMap function.
Hope this helps.
You can try as suggested by Nicole that will work out!