topic Re: load & join in QlikView

load & join

Anonymous — Thu, 23 Jun 2016 08:14:56 GMT

hi,

i have table with kod emply and name

em-id

name

the secend table have columns for each role , the data is "em-id"

meneger-id

first-id

secend-id

how do i conect this 2 tables ?

to show the names for each role and not the em-id

thanks'

yarin

Re: load & join

migueldelval — Thu, 23 Jun 2016 08:18:09 GMT

Hi Yarin,

I can´t understand you so well. Could you attach an example?

Regards

Miguel del Valle

Re: load & join

PrashantSangle — Thu, 23 Jun 2016 08:25:34 GMT

Hi,

Can you provide sample data of two table or provide

those 2 table metadata.

Regards

Re: load & join

maniram23 — Thu, 23 Jun 2016 08:29:31 GMT

Hi,

In your tables you don't have any common field of two table.

just you can take one more field as rownumber (rowno()) in your application.

Than you can join the tables.

T1:

Load rowno() as row,

emp_id

from

(.....)

left join T1:

load rowno() as row,

name

from

(.......)

Regards

Re: load & join

qlikview979 — Thu, 23 Jun 2016 08:37:58 GMT

Hi,

I can't understand this ,not sure

T1:

load

em-id

name

concatenate

T2:

load

em-id

meneger-id

first-id

secend-id

Re: load & join

ankit777 — Thu, 23 Jun 2016 08:41:34 GMT

you can make a join on the basis of em-id(which is the common field in both tables).

Re: load & join

marcus_malinow — Thu, 23 Jun 2016 08:59:45 GMT

Ok, if I understand this correctly, you can use a mapping load here:

NameMap:

MAPPING LOAD

em-id,

name

FROM [first table];

SecondTable:

LOAD

meneger-id,

ApplyMap('NameMap', meneger-id) as managername,

first-id,

ApplyMap('NameMap', first-id) as firstname,

secend-id,

ApplyMap('NameMap', secend-id) as secondname

FROM [second table]