Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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.