Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

arvindrj
New Contributor

Link the column with other table

Hi ,

    I have two tables. One is transaction and other one is Price master

Transaction:  

LOCATIONITEM CODEDATEQUANTITY
ChennaiA00105-Jan-184
ChennaiA00107-Feb-182
ChennaiB00106-Feb-182
ChennaiB00105-Jan-183
BangaloreB00105-Feb-181
BangaloreB00106-Feb-183
BangaloreC00108-Jan-182
BangaloreC00109-Feb-185
MumbaiA00105-Jan-182
MumbaiA00107-Feb-181
MumbaiC00107-Jan-182
MumbaiC00108-Feb-183

Price Master:

    

LOCATIONITEM CODEFROM DATETO DATEPRICE
Chennai31-Jan-18100100
Chennai28-Feb-18110110
C00131-Jan-18210210
C00128-Feb-18200200
A00131-Jan-18110110
A00128-Feb-18115115
B00131-Jan-18150150
B00128-Feb-18200200

I need to link the Price column which is in price master with Transaction column based on location and Item Code and also from date to To date.

The Sample output should be like this.

    

LOCATIONITEM CODEDATEQUANTITYPRICE
ChennaiA00105-Jan-184100
ChennaiA00107-Feb-182110
ChennaiB00106-Feb-182200
ChennaiB00105-Jan-183150
BangaloreB00105-Feb-181200
BangaloreB00106-Feb-183200
BangaloreC00108-Jan-182210
BangaloreC00109-Feb-185200
MumbaiA00105-Jan-182110
MumbaiA00107-Feb-181115
MumbaiC00107-Jan-182210
MumbaiC00108-Feb-183200
1 Reply
agomes1971
Valued Contributor II

Re: Link the column with other table

Hi,

have you tried this:

Trans:

LOAD LOCATION,

     [ITEM CODE],

     DATE,

     QUANTITY

FROM

[Data.xls]

(biff, embedded labels, table is Transaction$);

Left Join

//NoConcatenate

Master_Price:

LOAD [ITEM CODE],

     PRICE

FROM

[Data.xls]

(biff, embedded labels, table is [Price Master$]);

HTH

André Gomes