Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
daisy1438
Contributor III
Contributor III

problem with join

Hi

I have tow tales T1 and T2.

fields Risk_ID      L1_ID     date    Satus

script

T1:

Risk_ID & L1_ID& date   as key,

Risk_ID ,

L1_ID,

Date,

  Satus;

outer join(T1)

T2:

Risk_ID & L1_ID& date   as key,

//Risk_ID ,

// L1_ID,

//Date,

  Satus;

The above table I am not comment the Status field because in first table status is open and t2 table status is closed.

problem is using  key between two tables L1_ID and Date data not merge.if un comment the L1_ID and Date in table t2 the values come up.but it showing more values. How to resolve this.

1 Reply
mark6505
Partner
Partner

HI,

Probably going to need some more information to help on this one, some example data would be helpful.

What happens when trying to join them i.e. the resulting table?

From the information i would guess that the Data in the Key in in table 1 and 2 is different so they are not joining. The must match exactly, case as well.

Also notice in you script you use date in the key and the field below is Date, the must both be Date as it is case sensitive.

Mark