3 different feild 1 discreption

[Anonymous]

hi,

i have in one table with 3 feild "emploey number" (like this:emp1,emp2,emp3)

and another table with Their names,

how do i conect this 2 tables ?

thanks'

yarin.

[#2]

hi

if you connect both table.

then simply load both table and make the field name are same in both table, because in qlikview if same name field are automatically concate.

example-

Table1:

load

emp1,

emp2,

emp3

from Table1;

join

Table2:

load

[column1] as emp1,

[column2] as emp2,

[column3] as emp3

from Table2;

[Anonymous]

hi,

i don't think that i can connect this 2 tables ,

in table  i have their emp.num

and in table tow i have their names but the table are like this:

emp.num

name

i don't have name for every kind of emp.

thanks'

yarin

[brindlogcool]

It would be helpful if you could provide a sample file?

[nilesh_gangurde]

Hi,

you can do it following way and have three discriptions:

example-

Table1:

load

emp1,

emp2,

emp3

from Table1;

Left  join

load

[column1] as emp1,

Description as Description1

from Table2;

Left  join

load

[column2] as emp2,

Description  as  Description2

from Table2;

Left  join

load

[column3] as emp3,

Description  as  Description3

from Table2;

Hope this will help.

-Nilesh

[#6]

It will be easier to resolve the issue if you can share a sample file with small data.

[MK_QSL]

Create a Mapping Load Table with Employers ID and Emp Name.

Use three different applymap in each table or field.