Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Linking Tables

Hi,

I would like to ask for help. I have 3 tables that needs to be linked to each other.

Table 1

Load

     DATE

     LINEPRICE as LINEAMOUNT,

           ENTRYID & '-' & DATE &'-'& BRANCHNAME as GNDLINEKEY,

     ITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY

    

Resident PARENT_TEMP

where VOIDED <> 1;

Table 2

LOAD

     COMBOITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY

Resident GNDITEM_COMBO_TEMP

where VOIDED <> 1;

Table 3

LOAD

       ENTRYID & '-' & date(floor(TRIM(DOB))) &'-'& TextBetween(FileBaseName(),'_','_') as GNDLINEKEY

FROM

$(DIR1)KR_*_GNDLINE_2012.qvd

(qvd)

I need to link table 2 and 3 without creating loops.

Thanks in advance,

Janzen

2 Replies
Not applicable

Re: Linking Tables

Please any idea on this?

sujeetsingh
Honored Contributor III

Re: Linking Tables

Just go with joins or concatenatio...whatever suits your requirement...

Just join them in another table and drop the both

Community Browser