topic Re: 3 different feild 1 discreption in QlikView

3 different feild 1 discreption

Anonymous — Tue, 28 Jan 2014 04:27:35 GMT

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.

Re: 3 different feild 1 discreption

Tue, 28 Jan 2014 04:49:28 GMT

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;

Re: 3 different feild 1 discreption

Anonymous — Tue, 28 Jan 2014 04:59:40 GMT

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

Re: 3 different feild 1 discreption

brindlogcool — Tue, 28 Jan 2014 05:08:38 GMT

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

Re: 3 different feild 1 discreption

nilesh_gangurde — Tue, 28 Jan 2014 05:22:56 GMT

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

Re: 3 different feild 1 discreption

Tue, 28 Jan 2014 08:19:55 GMT

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

Re: 3 different feild 1 discreption

MK_QSL — Tue, 28 Jan 2014 08:23:18 GMT

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

Use three different applymap in each table or field.