
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No Concatenate joining the tables Qlik Sense
Hi,
I have two Tables T1 and T2 with same column names C1,C2,C3.
Table X;
Load
C1,
C2,
C3
Resident T1;
Table Y:
NoConcatenate
Load
C1,
C2,
C3
Resident T2;
I have used above script but still joining the table in data model.
Kindly help.
Thanks
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this
Table X;
Load
C1,
C2,
C3
Resident T1;
Table Y:
NoConcatenate
Qualify *;
Load
C1,
C2,
C3
Resident T2;
Unqualify;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this
Table X;
Load
C1,
C2,
C3
Resident T1;
Table Y:
NoConcatenate
Qualify *;
Load
C1,
C2,
C3
Resident T2;
Unqualify;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This will create a synthetic key. Either rename the fields in one of the tables, e.g. C1 AS T2_C1 or use Qualify:
Table X:
Load
C1,
C2,
C3
Resident T1;
Table Y:
QUALIFY *;
Load
C1,
C2,
C3
Resident T2;
UNQUALIFY *;
Edit: Chennaiah was faster

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
It is not joining the tables. But, when i would like to do
Table Z:
Load
C1,C2,C3
Resident X;
Concatenate(Table Z)
Load
C1,C2,C3
Resident Y;
Error: C1 not found in Resident Y

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is this happening after you use QUALIFY?
First, TableZ will be concatenated to TableX, so maybe drop TableX.
Second, since you use QUALIFY, C1 does not exist in TableY, it is called something like TableY.C1. Use Load*Resident TableY.
By the way, I am not sure what you trying to achieve with all the resident loads. If you give an example it will be easier for us to help.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi.
It comes as TableY.C1 but it is difficult to read.
I have complex data. So, i need to do this. It was working in Qlikview but i face issue in Qlik Sense.
Thanks..


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Pavan R,
With noconcatenate the tables will joins (logically ofcourse), the keyword prevents only the appending.
So you can use qualify or renaming the fields as mentioned Ivan and Chennaiah.
If you don't want to have any connection between the tables, and the qualify don't work as expected, use the renaming.
The association of tables based on the common field names.
G.
