topic Re: Problem Seeing Full Data in QlikView

Problem Seeing Full Data

Thu, 10 Jul 2014 09:35:24 GMT

Hi.

I have an excel table loaded with this data

YearMonthCar Expense

201411 100

201421 100

201431 100

Sql table with this data

YearMonthCar Income

201411 100

201431 300

The common key- is YearMonthCar

when i load the data in qlikview table the data from second row from excel table is missing.

I understand why because of the join,

but how do i fix it?

Re: Problem Seeing Full Data

datanibbler — Thu, 10 Jul 2014 09:38:44 GMT

Hi,

by default, QlikView does an inner join - which means only those records present in BOTH tables are in the output.

If you load your Excel table first, use a LEFT JOIN - that will keep all those records that are in the primary_table (which would be your Excel table), whether they match or not - and add those records from the other table that match.

The best and easiest way to visualize the different kinds of JOINs is, I think, with two overlapping circles.

Re: Problem Seeing Full Data

alexandros17 — Thu, 10 Jul 2014 09:39:26 GMT

What kind of join have you done? You need a full join (not left or right), send me your script (or document)

Re: Problem Seeing Full Data

Thu, 10 Jul 2014 10:03:05 GMT

the problem is that my primary table is the one from sql

Re: Problem Seeing Full Data

Anonymous — Thu, 10 Jul 2014 10:08:23 GMT

Hi,

You may have to use trim function to remove unwanted space from start and end of data before join them. Sometimes in excel we get space at the end of data.

Trim(YearMonthCar) as YearMonthCar