Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alanathor
New Contributor

Issues with Joins on queries

HI Guys

I'm pretty new at QLik View and have 'almost' successfully able to load two MYSQL queries, and to JOIN the fields into a single column.

Individually both Queries do what they need to do.

The first thing I did was paste a MYSQL query and save qwv file

Binary ;

I then created a new query(Being the Master), and did a reconnect on the OBDC DB added another query; below.

I made sure that all the field names from first and second queries are common.

Capture.PNG

The system picked up all fields and created Synthetic keys for all the DUPLICATED field names.

The issue I have is that one off the fields(probably on how the Table join is done automatically;

unnecessarily truncates (ie create only one value off) off the fields; which should be a data field.

The fields pulled in are:

CODE              (COMMON)

CUSTOMER    (COMMON)

REP                  (COMMON)

CATEGORY      (COMMON)

SUBSCRIPTION (COMMON) *** THIS IS THE ONE THAT APPEARS TO BE TRUNCATING - SEE IN RED RESULT BELOW

CHARGE            (COMMON)

COM_PER          (COMMON) *** COULD BE BUT DOESN'T APPEAR TO BE AT FIRST GLANCE

COMM_TOT        (COMMON)

DATE_ACT          (NOT COMMON ONLY IN QUERY 2)


AGAIN INDIVIDUALLY BOTH WORK FINE AND NO TRUNCATING HAPPENS

Capture2.PNG

1 Reply
alanathor
New Contributor

Re: Issues with Joins on queries

Solved...

Was in fact duplicate fields on Table view; used a unique key

Community Browser