Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
];
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.
Hi liongil01
If you got solution from the thread then mark correct or helpful and close the thread.
Regards,
Anand