Interval match issue

[nareshthavidishetty]

Hi,

I have used the interval match to pull [# Sales Closed] information for start and closure date.

But I'm not able to get the map the information.

Table1:

load

date(Calendar_Date,'DD-MMM-YYYY')        as    [Calendar Date]

,Closed                                                          as    [SC# SALES Closed]

FROM

[..\5_QVD\F_CAP_Sales_Handling.qvd]

(qvd);

Table2:

load

date(Floor(Start_Date),'DD-MMM-YYYY')                 as       [Start Date]

,date(Floor(Closure_Date),'DD-MMM-YYYY')           as       [Closure Date]

FROM

[..\5_QVD\D_CAP_SALES1.qvd]

(qvd) where Last_Version='Y' ;

TempInterval:

intervalmatch([Calendar Date])

load

          [Start Date] , 

          [Closure Date]

                 resident Table1;

Reuired output:

Start date	Closure date	[SC# SALES Closed]
10-12-2017	01--1-2018	234
20-11-2016	31-10-2018	6258

Thanks,

KIshore

[Gopi_E]

Hi Naresh,

try like this

TempInterval:

intervalmatch([SC# SALES Closed])

load

          [Start Date] ,

          [Closure Date]

           resident Table2;

[Anonymous]

Hi Naresh,

Everything looks good with the above script, just put inner join before interval match to avoid synthetic keys and I am assuming that resident table is a typo, It should be Table2 if it's not a typo.

And one more question is that can we know the format of data in fields Calendar Date, Start Date, and Closure date. If you give those formats it would be easy for us to resolve ur issue.

If you are having a different format that dd-mm-yyyy in your source then this will not work. You should use both the above date #() for interpreting and date() for showing.

Try above and let us know. If its not working then please give us more information.

Thanks,

Sarat.K