how to use Interval Match for following requirement

[vikasmahajan]

Dear All

I have following fact table and slabs table

%COGS	%Gr Margin	COGS	PordCode	ProdName	Product Code	Sls Amt
20	80	35	FDCEBT001	CYCLOPAM TAB - SALE 10'S	1CY4	173

this are fact table and following are range table I want to use interval match if  my [%Gr Margin ] field falling under (range fr To) then

respective product class should attached. ( for E.g  1CY4 will be getting Class -> A2 ( becase 1cy4 falls in (80-89) )

I have attached QVW file also.

Product_Class	RANGE_FROM	RANGE_TO
A1	90	999999999
A2	80	89
A3	70	79
B4	60	69
B5	50	59
C1	40	49
C2	30	39
C3	20	29
C4	10	19
C5	0	9

Thanks

Vikas

[ali_hijazi]

IntervalMatch([%Gr Margin])LOAD RANGE_FROM,RANGE_TO Resident DatesTable;

Join(DatesTable)

LOAD Distinct RANGE_FROM,RANGE_TO,[%Gr Margin] Resident temp;

drop Table temp;

//you can make an inner join or left join between DatesTable and Fact Table

[vikasmahajan]

Thanks for reply

I have not use temp table ??? 

Can you please give me full script ?

Vikas

[ali_hijazi]

temp:

IntervalMatch([%Gr Margin])LOAD RANGE_FROM,RANGE_TO Resident DatesTable;



inner Join(DatesTable)

LOAD Distinct RANGE_FROM,RANGE_TO,[%Gr Margin] Resident temp;

drop Table temp;

[ali_hijazi · Accepted solution]

intervalMatch returns a table, name it temp or anything you like

[vikasmahajan]

still I am not getting results ? Interval Match will works for NO ?

vikas

[vikasmahajan]

Can u please create qvw and attach if possible .

Urgent help Please

Vikas

[ali_hijazi]

I attached the document in my previous reply

check please

I binary-loaded data from the document you supplied and added the interval match script

[Anonymous]

Hi,

The following attachments might help you..

Go through it once.....

[vikasmahajan]

Thanks

Please check 1cy4 cyclopam is not showing Class.

Vikas

Please check I have attached excel sheet of some records.

Vikas