topic Re: Qlikview data from difference sources pulling. in QlikView

Qlikview data from difference sources pulling.

Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: Qlikview data from difference sources pulling.

dsharmaqv — Wed, 04 Jan 2017 09:08:04 GMT

Field name must be same to link tables.

Table A

Emp Name

Hrs Worked

Table B

Emp Name

Dayrate of salary

Re: Qlikview data from difference sources pulling.

Wed, 04 Jan 2017 10:30:28 GMT

Thank you very much for the help.

Re: Qlikview data from difference sources pulling.

dsharmaqv — Wed, 04 Jan 2017 11:21:40 GMT

Mark the answer as correct to close the discussion.

Thanks

Re: Qlikview data from difference sources pulling.

robert_mika — Wed, 04 Jan 2017 11:30:32 GMT

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,

Re: Qlikview data from difference sources pulling.

martynlloyd — Wed, 04 Jan 2017 11:42:35 GMT

Hojun,

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

Can you post some examples?

Marty.