Hi all,
I have three tables
Extract
Position | System Group | Object name |
Employee
User ID | Name | Position | System Group |
GroupSharedUser
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 ID | Name | Position | System Group | UniqueName |
GOODDAD | DANIEL GOODDAY | 5001005 | AuditCreator | AuditCreator |
GOODDAD | DANIEL GOODDAY | 5001005 | AuditCreator | GeneralGroup |
GOODDAD | DANIEL GOODDAY | 5001005 | AuditCreator | ReadOnly |
GOODDAD | DANIEL GOODDAY | 5001005 | AuditCreator | PurchasingUser |
GOODDAD | DANIEL GOODDAY | 5001005 | GeneralGroup | AuditCreator |
GOODDAD | DANIEL GOODDAY | 5001005 | GeneralGroup | GeneralGroup |
GOODDAD | DANIEL GOODDAY | 5001005 | GeneralGroup | ReadOnly |
GOODDAD | DANIEL GOODDAY | 5001005 | GeneralGroup | PurchasingUser |
GOODDAD | DANIEL GOODDAY | 5001005 | ReadOnly | AuditCreator |
GOODDAD | DANIEL GOODDAY | 5001005 | ReadOnly | GeneralGroup |
GOODDAD | DANIEL GOODDAY | 5001005 | ReadOnly | ReadOnly |
GOODDAD | DANIEL GOODDAY | 5001005 | ReadOnly | PurchasingUser |
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