Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Naresh,
try like this
TempInterval:
intervalmatch([SC# SALES Closed])
load
[Start Date] ,
[Closure Date]
resident Table2;
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