Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wholelottared
Contributor III
Contributor III

How do I properly concatenate and rename?

Hello! I have two tables with similar data that I'm trying to first concatenate and rename (editing via Data Load Editor). Could I please get help

LANID is table 1. PIV is table 2. They both have identical tables that they need to be group together despite different names. For example LANID.Realm needs to matched together with PIV.Realm. How to I concatenate and then change the both tables to "Realm" so they data is together in one table. 

Unqualify *;

[LANID]:
LOAD
[Username] AS [LANID.Username],
[Realm] AS [LANID.Realm],
[Login Time] AS [LANID.Login Time],
[Device ID] AS [LANID.Device ID],
[Role] AS [LANID.Role],
[Device OS] AS [LANID.Device OS],
[Office] AS [LANID.Office],
[Office2] AS [LANID.Office2]
FROM [lib://AttachedFiles/example file.xlsx]
(ooxml, embedded labels, table is LANID);


[Users1]:
Left Join
LOAD
[Username] AS [LANID.UserName],
[Email]
FROM [lib://AttachedFiles/example user file.xlsx]
(ooxml, embedded labels, table is Users);

 

Concatenate

[PIV]:
LOAD
[Username] AS [PIV.EmailAddress],
[Realm] AS [PIV.Realm],
[Login Time] AS [PIV.Login Time],
[Device ID] AS [PIV.Device ID],
[Role] AS [PIV.Role],
[Device OS] AS [PIV.Device OS],
[Office] AS [PIV.Office],
[Office2] AS [PIV.Office2]
FROM [lib://AttachedFiles/example file.xlsx]
(ooxml, embedded labels, table is PIV);

[Users1]:
Left Join
LOAD
[Email] AS [PIV.EmailAddress],
[Username]
FROM [lib://AttachedFiles/example user file.xlsx]
(ooxml, embedded labels, table is Users);

1 Reply
qlikerB96
Contributor III
Contributor III

Hi,

The first rule of concatenating tables is to give same names to the fields, in this case the QS will automatically concatenating the tables. 

There is a very good explanation here: Concatenate tables !

All you have to do is load the table as the required name "Relm" and give the same name to the fields.

Good luck,

B.