Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
First post here and new to the scripting of Qlik
I've got a slight issue with a table I'm loading. Due to the format of the data, it comes out something like this (the main column i'm having issue with, the rest of the data is in the correct format):
Workcenter/Resource(Customised) |
BR |
BR |
BR |
BR |
BR |
BR |
SOUTH WEST |
SOUTH WEST |
SOUTH WEST |
SOUTH WEST |
SOUTH WEST |
SOUTH WEST |
WILLIAM FROST |
WILLIAM FROST |
WILLIAM FROST |
WILLIAM FROST |
WILLIAM FROST |
WILLIAM FROST |
CARL HEWLETT |
CARL HEWLETT |
CARL HEWLETT |
CARL HEWLETT |
CARL HEWLETT |
CARL HEWLETT |
WW01/4997225 |
WW01/4997225 |
What I need to do is have it set up like
Cost Centre | FLM | Performance Manager |
S241 | Erick Muriithi | William Frost |
S242 | David R Jones | William Frost |
S243 | David B Smith | William Frost |
S244 | Carl Hewlett | William Frost |
S245 | Paul Garland | William Frost |
As you can see, Carl Hewlett is a FLM to the PM William Frost
I have that table as a lookup table in my script already
Basically, is there a way to link that one column to that Lookup table?
If I'm not making much sense I do apologise
Look forward
Ant
The way you cerate link's to your lookup table is by calling the column from table1 the exact same name as the column you want to link on in table2.
I'm not sure if that helps, if not, could you upload your document?
Hi,
I just solved this by left joining the Lookup table twice, once for FLM, once for Performance Manager
Thanks for your help
Ahhh, I see. Another approach if you want to keep the table's separate with one being a dimension table, is to concatenate the field's together in both table, something like:
FLM + '|' + [Performance Manager] as JoinKey
in Table A
and
FLM + '|' + [Performance Manager] as JoinKey
In Table B.
Glad you found a solution!