Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i hav attached an excel sheet which has some promotion details. this sheet going to get updated weekly.
i hav the following tables from qvd.
Tab_Name:
LOAD BRH,
DATE(DEC, 'DD/MM/YYYY') AS SDATE,
MONTH(DEC) AS BMONTH,
YEAR(DEC) AS BYEAR,
Name,
PNo,
Des,
Sales,
Quantity
FROM
[QVD\ Tab_Name.qvd]
(qvd);
Concatenate
Tab2:
LOAD ACC_CODE,
BCODE,
BNAME as Branch,
SORDER
FROM
[QVD\ Tab2.qvd]
(qvd);
Now, when i select a particular date, the report ll display the details of the above tables. also it should check the details of the excel sheet for the same date & any data found, report should display that details too.
wat may be the solution for this requirement. please help me in this regard asap.
You should use intervalmatch() for this.
Use this thread for guidance IntervalMatch function
Hi PRRAJENDRAN,
As per your script stated above ther is no two matching date fileds in Qvd and excel.
I assume you need to reame the excel file date fileds. Then only you can see the report from both tables.
Hi Rajendran
Please use interval match function.
//Try below code in script
WeeklyUpdate:
LOAD Week,
StartDate,
EndDate,
PartNo,
Description
FROM
Tab_Name:
LOAD BRH,
DATE(DEC, 'DD/MM/YYYY') AS SDATE,
MONTH(DEC) AS BMONTH,
YEAR(DEC) AS BYEAR,
Name,
PNo,
Des,
Sales,
Quantity
FROM [QVD\ Tab_Name.qvd](qvd);
Concatenate
LOAD ACC_CODE,
BCODE,
BNAME as Branch,
SORDER
FROM [QVD\ Tab2.qvd](qvd);
Left join(Tab_Name)
Intervalmatch(SDATE)
LOAD StartDate,EndDate
RESIDENT WeeklyUpdate;
Left join (Tab_Name)
LOAD Week,
StartDate,
EndDate,
PartNo,
Description
Resident WeeklyUpdate;
drop table WeeklyUpdate;
Regards
Neetha
thank u very much Neetha.
ll try this script.
HI PR
Instead of Using Interval Match You can Use Reference Dates for Interval dates,
Go through the following Link
sorry neetha. its not working.
any other suggestions..pls
Hi Rajendran,
Please can you upload QVD file or part of data,so can help.
Regards
Neetha