I need to create a intervalmatch for employee Yearly Sales Target.
So i have created Inline Data
load * inline
Load distinct Min_Sales, Max_Sales
Problem is... i think the intervalmatch should not be "Sales". My orders and sales_target table is 2 diff table. But i think i need to create an expression, such as (total_sales/target)*100 as percentage_achieved. Then in my intervalmatch table, i should interval match(percentage_achieved).
both tables rite now are linked with orders_key.
You could use a mapping table approach (using MAPPING LOAD prefix and ApplyMap() ) or a JOIN to create a single table with Total_Sales and Target values. Then do a resident LOAD to create your percentage column and use IntervalMatch() to match against your grades (maybe using year as key field in the IntervalMatch() extended syntax?).