Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Beginner struggling with scripting

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
FLMPerformance
  Manager
S241Erick MuriithiWilliam Frost
S242David R JonesWilliam Frost
S243David B SmithWilliam Frost
S244Carl HewlettWilliam Frost
S245Paul GarlandWilliam 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

3 Replies
joshabbott
Not applicable

Re: Beginner struggling with scripting

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?

Not applicable

Re: Beginner struggling with scripting

Hi,

I just solved this by left joining the Lookup table twice, once for FLM, once for Performance Manager

Thanks for your help

joshabbott
Not applicable

Re: Beginner struggling with scripting

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!