retrieving data from excel & hav to match with the records from qvd

[#1]

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.

[#2]

You should use intervalmatch() for this.

Use this thread for guidance IntervalMatch function

[#3]

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.

[Anonymous]

Hi Rajendran

Please use interval match function.

//Try below code in script

WeeklyUpdate:
LOAD Week,
     StartDate,
     EndDate,
     PartNo,
     Description
FROM

(biff, embedded labels, table is Sheet1$);

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

[#5]

thank u very much Neetha.

ll try this script.

[rajkumarb]

HI PR

Instead of Using Interval Match You can Use Reference Dates for Interval dates,

Go through the following Link

Creating Reference Dates for Intervals

[#7]

sorry neetha. its not working.

any other suggestions..pls

[Anonymous]

Hi Rajendran,

Please can you upload QVD file or part of data,so can help.

Regards

Neetha