topic Re: Beginner struggling with scripting in QlikView

Beginner struggling with scripting

Thu, 31 Jul 2014 12:35:55 GMT

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)

SOUTH WEST

WILLIAM FROST

CARL HEWLETT

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

Re: Beginner struggling with scripting

joshabbott — Thu, 31 Jul 2014 12:46:14 GMT

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?

Re: Beginner struggling with scripting

Thu, 31 Jul 2014 13:12:27 GMT

Hi,

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

Thanks for your help

Re: Beginner struggling with scripting

joshabbott — Thu, 31 Jul 2014 13:16:37 GMT

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!