Discussion board where members can get started with QlikView.
I'm a little bit of blurry on the JOIN part. Say I have two table as pictured below:
The table Calendar contains the FiscalYear, FiscalMonth and Days.
Table Revenue might not have all of the revenue of a particular Fiscal Year and FiscalMonth.
To which table must a table join and what type of join must I use to derive the table Revenue1?
Thank you for your kind attention guys. Appreciate any suggestions/opinions and advices on this one. Thanks guys
LOAD * Inline [
Load FiscalYear,FiscalMonth,Days,Amount,If( IsNull(Country),Previous(Country),Country) Resident Calendar;
Drop table Calendar;
View solution in original post
Load * From Calendar;
Load * From Revenue;
Load *,If( IsNull(Country),Previous(Country),Country) Resident Calendar;
Thank you for your reply. Really appreciate it Have a nice day!