Qlik Community

New to Qlik Sense

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Violent_Democracy
Contributor
Contributor

Joining two tables to a third

Hi all,

I have three tables

Extract

PositionSystem GroupObject name

 

Employee

User IDNamePositionSystem Group

 

GroupSharedUser

UniqueNameUser ID

 

Currently I am using the following formula

Extract:
LOAD
[Position],
[System Group],
[Object name]
FROM [lib://
(ooxml, embedded labels, table is Extract);

Join (Extract)

Employee:
LOAD
[User ID],
[Name],
[Position],
[System Group]
FROM [lib://
(ooxml, embedded labels, table is Employee);

GroupSharedUser:
LOAD
[UniqueName],
[User ID]
FROM [lib://
(ooxml, embedded labels, table is GroupSharedUser);

This has the following output

User IDNamePositionSystem GroupUniqueName
GOODDADDANIEL GOODDAY5001005AuditCreatorAuditCreator
GOODDADDANIEL GOODDAY5001005AuditCreatorGeneralGroup
GOODDADDANIEL GOODDAY5001005AuditCreatorReadOnly
GOODDADDANIEL GOODDAY5001005AuditCreatorPurchasingUser
GOODDADDANIEL GOODDAY5001005GeneralGroupAuditCreator
GOODDADDANIEL GOODDAY5001005GeneralGroupGeneralGroup
GOODDADDANIEL GOODDAY5001005GeneralGroupReadOnly
GOODDADDANIEL GOODDAY5001005GeneralGroupPurchasingUser
GOODDADDANIEL GOODDAY5001005ReadOnlyAuditCreator
GOODDADDANIEL GOODDAY5001005ReadOnlyGeneralGroup
GOODDADDANIEL GOODDAY5001005ReadOnlyReadOnly
GOODDADDANIEL GOODDAY5001005ReadOnlyPurchasingUser

 

I want a new column at the end of the table that shows (in a count form of 1,2, 3 etc) where UniqueName has more access than System Group. So using the above example I would have a new column that showed a 1 (Because PurchasingUser exists in UniqueName but not System Group).

Also, is this the most efficient method of joining the tables together to produce the output table I want?

Thanks

0 Replies