Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Solved...
Was in fact duplicate fields on Table view; used a unique key