two weeks intervalMap

[#1]

I´m trying to make a 2 week interval, but having trouble.

I use this but doeent work

InterlvaMap:

Mapping Load * inline[

key, label

1, 1-2

2, 3-4

3, 5-6

.................and so on

]

;

MAP label USING IntervalMap

Load

weeknumber as label

I got a field weeknumber

[sushil353]

Try this:

InterlvaMap:

Mapping Load * inline

[

key, label

1, 1-2

2, 3-4

3, 5-6

];

Map weekno using InterlvaMap;

tab1:

LOAD * Inline

[

weekno

1

2

3

];

[sushil353]

MAP label USING IntervalMap

Check your spelling with mapping table

InterlvaMap and USING IntervalMap

[#4]

firstly

you make interval by this syntax for week.

class(sum(week),1).

then try mapping

[#5]

Hi

vishwaranjan

I´m totally blank regarding your answer.

what does

class(sum(week),1).

do?

Please write some of the script.

What I´m trying to gain by the 2 weeks interval, - is how many items sold per first 2 weeks, second 2 weeks - third

2 weeks...... and so on

[#6]

My spelling in the script is ok - sorry for wrong spelling here

[#7]

the above post use for making Interval.

If your interval are already hard coaded. then try this,

InterlvaMap:

Mapping Load * inline

[

key, label

1, 1-2

2, 3-4

3, 5-6

];

Map weekno using InterlvaMap;

tab1:

LOAD * Inline

[

weekno

1

2

3

];

what exactly want the ouput Explain?

[#8]

I have already tried but it does nothing??

[#9]

My script now looks like this

IntervalMap:

Mapping Load * inline

[

key, label

1, 1-2

2, 3-4

3, 5-6

];

Map weekno using IntervalMap;

tab1:

LOAD * Inline

[

weekno

1

2

3

];

load weeknumber as twoweeks

resident [tab1];

so good so far - I can make a field twoweeks, but it doesnt filter with the rest of the datafields???

[sushil353]

Check the table viewer.. ctrl+T.. 

check if the table is linked with the other tables or not..

if not. then try to rename the field in such a way so that they can link with the other tables.

HTH

Sushil