Joining tables

[#1]

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

[Jason_Michaelides]

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

[#3]

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,

[Jason_Michaelides]

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.

[#5]

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

[#6]

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

[Jason_Michaelides]

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

[#8]

No Changes!

Thxs

[Jason_Michaelides]

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;

[Jason_Michaelides · Accepted solution]

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;