Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
intervalMatch returns a table, name it temp or anything you like
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
Thanks for reply
I have not use temp table ???
Can you please give me full script ?
Vikas
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;
intervalMatch returns a table, name it temp or anything you like
still I am not getting results ? Interval Match will works for NO ?
vikas
Can u please create qvw and attach if possible .
Urgent help Please
Vikas
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
Hi,
The following attachments might help you..
Go through it once.....
Thanks
Please check 1cy4 cyclopam is not showing Class.
Vikas
Please check I have attached excel sheet of some records.
Vikas