Discussion board where members can get started with Qlik Sense.
I am generating a big daily report that is combined from a few tables,
at the moment this report is cumulative and i want to turn this report to daily feeds (only the incremental addition from the previous day)
it came to a point that i have one very big table that has more then 100k rows(SerialOutDailyReport)
and another table that after some filters consists only the orders i want to show in the report -much smaller table(Delivery Update)
this is the tables as they appear in the script:
BoxName_Old AS Box_ID,
ReportDate_US AS CSV_Upload_Date,
where VendorCode_Old='010012' AND IsStaticOrTransit='InTransitToCustomer';
SOid as Micro_SO
InnerNumber as BoxNumber_Old ,
SerialNumber as Serial
Store * From SerialOutDailyReport into [lib://_administrator)/SerialOutDailyReport_Temp1.qvd];
Drop table SerialOutDailyReport;
Store SerialOutDailyReport into "lib://CSV/SHP$(vMicroSLP)_$(vDateS)_$(vTimeS)_F.csv"(txt, delimiter is '|');
and my other table is:
FROM [lib://=_administrator)/DimDelivery.qvd] (qvd) where (DeliveryType='Sloc To Sloc' and ShipmentDate=(today()-1)) or PickPackDate=date(today()-1);
Store * From DeliveryUpdate into [lib://_administrator)/DeliveryUpdate.qvd];
drop table DeliveryUpdate;
the connection between the two tables is "LastOCNumber_Old".
i want the report to be the first table (SerialOutDailyReport) but only where the LastOCNumber_Old equals to the LastOCNumber_Old in the DeliveryUpdate table.
i have tried using inner join/right join/where clause but with no success, (each order number can have few serials)
If something is not clear enough i can attach some pics.
many many many thanks!
I believe inner join should work in this case: Try like this:
["lib://CSV/SHP$(vMicroSLP)_$(vDateS)_$(vTimeS)_F.csv"(txt, delimiter is '|')] // fix the path as per the actual name
View solution in original post
you can load SerialOutDailyReport table first and make a right join on it using DeliveryUpdate table, or you can load DeliveryUpdate table first and make left join on it using SerialOutDailyReport table.
Thank you very much guys!