topic Joining tables in QlikView

Joining tables

Thu, 22 Mar 2012 17:57:06 GMT

Hi,

I am loading two tables. one of them from txt file and the other using ODBC and SQL.

Anybody knows how to join them?

I have tried to put the same name on the key field but it didn't work

Thxs

Joining tables

Jason_Michaelides — Thu, 22 Mar 2012 18:01:03 GMT

Hi,

Can you post a script example? If you load two tables with a field in common then QlikView will link on that field automatically.

Hope this helps,

Jason

Joining tables

Thu, 22 Mar 2012 18:03:08 GMT

This is what I did.

In table A: I have OrgParty as OriginalParty

and in Table B ExParty as OriginalParty

I looked at the data module but they are not linked.

One of them showing as OriginalParty and the other ORIGINALPARTY

Thxs,

Joining tables

Jason_Michaelides — Thu, 22 Mar 2012 18:17:31 GMT

QlikView is extremely case sensitive. Make sure your load script has the same case for both sections. If you think it does already, please post your full script.

Joining tables

Thu, 22 Mar 2012 18:42:21 GMT

LOAD Distinct

globalCallID_callId As CallID,

callingPartyNumber As OriginalParty,

originalCalledPartyNumber As DestinationParty,

finalCalledPartyNumber As FinalParty,

duration As Duration,

timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h')) as TimeStamp,

subfield('$(File)','_',5) as SequenceNr

FROM

[$(File)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

***************************************************************************

ODBC CONNECT TO SNEEZY (XUserId is BeVZPHdJUKRGFIVKNCUeF, XPassword is OddIDHdJUKRGFIVKNCUIC);

Whowho:

Select WWFULLNAME As Name,

WWEXTENSN As OriginalParty,

WWDEPART As Department,

WWDIVSN As Division,

WWMGR As Manager

From LSELF.WHOWHO

Joining tables

Thu, 22 Mar 2012 18:47:19 GMT

I have no Idea why the SQL load is showing capital!

Joining tables

Jason_Michaelides — Thu, 22 Mar 2012 18:50:03 GMT

Hmmm...try adding a LOAD *; before the select statement.

Joining tables

Thu, 22 Mar 2012 18:52:19 GMT

No Changes!

Thxs

Joining tables

Jason_Michaelides — Thu, 22 Mar 2012 18:59:05 GMT

Try putting the aliases in the LOAD statement:

Whowho:

LOAD

WWFULLNAME As Name,

WWEXTENSN As OriginalParty,

WWDEPART As Department,

WWDIVSN As Division,

WWMGR As Manager

;

SQL Select WWFULLNAME As Name,

WWEXTENSN As OriginalParty,

WWDEPART As Department,

WWDIVSN As Division,

WWMGR As Manager

From LSELF.WHOWHO;

Joining tables

Jason_Michaelides — Thu, 22 Mar 2012 19:00:25 GMT

Oops!! I meant:

Joining tables

Try putting the aliases in the LOAD statement:

Whowho:

LOAD

WWFULLNAME As Name,

WWEXTENSN As OriginalParty,

WWDEPART As Department,

WWDIVSN As Division,

WWMGR As Manager

;

SQL Select WWFULLNAME,

WWEXTENSN,

WWDEPART,

WWDIVSN,

WWMGR

From LSELF.WHOWHO;

Joining tables

Thu, 22 Mar 2012 19:07:54 GMT

Worked fine.

Thxs,

Badr