Can i use Calculated Column for Interval match

[#1]

Hi Friends

I need to use a Calculated Column for interval match. I attached my script here. It execute with out error. But I Can't get the association b/w the interval match and my Calculated column

[MK_QSL]

May be try this

Sales:

LOAD [Order ID],

     Year,

     [Order Date],

     [Employee ID],

     Status,

     [Customer Name],

     [Product ID],

     [Shipped Date],

     [Shipping Fee],

     Taxes,

     [Order Total],

     Interval(Date(Floor([Shipped Date]))-Date(Floor([Order Date])),'D') as Days

FROM

[\\f-typhon\home2$\z014261\MyDocs\Sales Orders1.xls]

(biff, embedded labels, table is [Order List$]);

Inter:

LOAD * INLINE [

    Start, End, Order

    2, 5, Order1

    6, 10, Order2

    11, 15, Order3

    16, 20, Order4

    21, 25, Order5

    26, 31, Order6

];

Inner Join

IntervalMatch(Days, [Order ID])

LOAD Start, End, [Order ID] Resident Inter;

[#3]

Inner Join

IntervalMatch(Days, [Order ID])

LOAD Start, End, [Order ID] Resident Inter;

Manish it raise exception.. I didn't use that column in Inter table.

[#4]

Brother am really sorry I got my Output really Thankyou very much

[MK_QSL · Accepted solution]

Use this..

[#6]

Really awesome dude............