Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

How to join two joined tables with a newly formed column in one of the tables

Two tables are linked with a specific column.Now I have introduced a new column in the first table and want to join the second table on basis of the new cloumn

7 Replies
MVP & Luminary
MVP & Luminary

Then in one of the two tables rename the field that's currently used to link the tables so the tables won't be joined on that field.


talk is cheap, supply exceeds demand
Creator III
Creator III

but this field is also used  joined with other tables ..when I rename them the other joins are destroyed

May be like: QUALIFY , RELOAD in a new RESIDENT table and UNQUALIFY the field.

MVP & Luminary
MVP & Luminary

Then rename it the one table that you want to link on the other field.


talk is cheap, supply exceeds demand
Creator III
Creator III

do i use a mapping function in this regard? IF u see the join is not evident even though the two tables are joined with a key SURVEY_ID:

MVP & Luminary
MVP & Luminary

Sorry, but to me nothing in your screenshot is evident other that you seem to have loaded some data. I have no idea how that data is related never mind how you want it to be related. Can you post a small qlikview document with some example data? Or at least a screenshot of the data model as shown in the Table Viewer.


talk is cheap, supply exceeds demand
Creator III
Creator III

sorry for late upload