joining 2 tables

[swathidumpala]

Hi I am very new to Qlik sense.

I am building a Qlik excel report.

I need to join 2 tables as below.

TableA:
LOAD
Month,
CustomerId,
BranchKey,
active
FROM [lib://XXXXXXXXXXXXXXX]
(qvd) where Month='201905';

TableB:
LOAD
MONTH,
BSB,
DESC

FROM [lib:/YYYYYYYYYYYYYYYYYY]
(qvd);

I need to join the above 2 tables and get the distinct BranchKey from Table A, corresponding  DESC from Table B

and need to join on TableA.BranchKey =TableB.BSB.

Request you to help me on how to achieve it.

[Lisa_P · Accepted solution]

We can associate these two tables by renaming one of the fields to match the other, or join if the fields are the same. A warning Qlik Sense is case sensitive, so you may decide to rename BranchKey to BSB or vice verse using as in the load statement.

TableA:
LOAD
Month,
CustomerId,
BranchKey,
active
FROM [lib://XXXXXXXXXXXXXXX]
(qvd) where Month='201905';

//TableB:

Left Join(TableA):
LOAD
MONTH as Month,
BSB as BranchKey,
DESC

FROM [lib:/YYYYYYYYYYYYYYYYYY]
(qvd);

[swathidumpala]

Thanks Lisa.

It worked except Left Join(TableA):  I had remove the colon to made it work.

Thanks a lot!

[Lisa_P]

Yes,  sorry , my mistake

[swathidumpala]

Hi Lisa,

As an extension to it , I need to get the customer count from Table C , where C.customer_id=A.customer_id

group by A.Branch_key

So the output should be

     1                                 2                              3

A.Branch_key         B.DESC            C.Customer_Count

We have achieved till 2.

I am struck to go ahead.

Please advice!

[Lisa_P]

If this customer_id is a key field, are you expecting different values in each table ?

[swathidumpala]

Yes Lisa.

[swathidumpala]

sorry , actually they are different

ciskey from first table and

customer_id from second table.