Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Data Missing

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?

3 Replies
MVP
MVP

Re: Data Missing

t:

load * from excel;

join (t) load * from sqlserver;

t:

load * inline [

YearMonthCar   ,      Expense

201411         ,           100

201421         ,           100

201431         ,           100

];

join (t) load * inline [

YearMonthCar ,    Income

201411       ,        100

201431       ,        300

];

Re: Data Missing

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

Hi liongil01

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

Regards,

Anand

Community Browser