topic Re: Data Missing in QlikView

Data Missing

Thu, 10 Jul 2014 17:35:39 GMT

Hi.

I have an excel table loaded with this data (and more tables such as it)

YearMonthCar Expense

201411 100

201421 100

201431 100

Sql table (Primary 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) how do i get to present it,

even if i will need to create virtual lines in the primary table?

Re: Data Missing

maxgro — Thu, 10 Jul 2014 17:58:40 GMT

load * from excel;

join (t) load * from sqlserver;

load * inline [

YearMonthCar , Expense

201411 , 100

201421 , 100

201431 , 100

];

join (t) load * inline [

YearMonthCar , Income

201411 , 100

201431 , 300

];

Re: Data Missing

its_anandrjs — Thu, 10 Jul 2014 18:23:29 GMT

Every time we have try joining with the master table see the example below for that

Example:-

ExcelTable:

Load * Inline

[YearMonthCar, Expense

201411, 100

201421, 100

201431, 100

];

Left Join(ExcelTable) // Or Join(ExcelTable) if the Excel table is master table then try with Left join

Sqltable:

Load * Inline

[ YearMonthCar, Income

201411, 100

201431, 300

];

Note:- You get the problem due join.

Re: Data Missing

its_anandrjs — Fri, 11 Jul 2014 19:15:41 GMT

Hi liongil01

If you got solution from the thread then mark correct or helpful and close the thread.

Regards,

Anand