Qlikview data from difference sources pulling.

[#1]

Hello everyone!

I am a new Qlikviewer so I only have very basic knowledge.

I am trying to pulling data from different sources. From one source, I extracted employees` names and hour-worked. From the other source, I extracted employees` names (slightly different from the first one) and fixed dayrate of salary.

But since they are from different sources, Even though the two employees` names dimensions are basically the same, They are not linked to each other hence I cannot calculate. Is there anyway to link the two employees` names to each other so that when I click employees` names that came from a source I brought hour-worked, it is automatically connected to dayrate salary as well?

Thank you in advance,

HJ

[dsharmaqv]

Field name must be same to link tables.

Table A

Emp Name

Hrs Worked

Table B

Emp Name

Dayrate of salary

[#3]

Thank you very much for the help.

[dsharmaqv]

WC

Mark the answer as correct to close the discussion.

Thanks

[robert_mika]

If the fields names from those two data sources are different, you can assign new name by using AS clause.

Table1:

Emp as EmployeeName

...

Table2:

Employee as EmployeeName,

..

[martynlloyd]

Hojun,

Are you saying that the names may have difference spellings in each source?

Can you post some examples?

Marty.