group number by range

[markgraham123]

All,

I'm trying to group Days 0,1 into group1

0,1,2 - group2

0,1,2,3 - group 3

0,1,2,3,4 - group 4

0,1,2,3,4,5 - group5

0,1,2,3,4,5,6,7,8,9,10 - group 6

0....... infinity - group7

can someone please help.

[sunny_talwar · Accepted solution]

Try like this

Test:

LOAD * Inline

[

Days

0

1

0

1

2

0

1

2

3

0

1

2

3

4

0

1

2

3

4

5

0

1

2

3

4

5

6

7

8

9

10

];

Test2:

LOAD Days,

  'Day 1' as All_Days

Resident Test

Where Days <= 1;

Concatenate(Test2)

LOAD Days,

  'Day 2' as All_Days

Resident Test

Where Days <= 2;

Concatenate(Test2)

LOAD Days,

  'Day 3' as All_Days

Resident Test

Where Days <= 3;

Concatenate(Test2)

LOAD Days,

  'Day 4' as All_Days

Resident Test

Where Days <= 4;

Concatenate(Test2)

LOAD Days,

  'Day 5' as All_Days

Resident Test

Where Days <= 5;

Concatenate(Test2)

LOAD Days,

  '6-10' as All_Days

Resident Test

Where Days <= 10;

DROP Table Test;

EXIT Script

[markgraham123]

So, 'if' statement would not work here right?

[sunny_talwar]

Don't think so...

[markgraham123]

Thanks a lot sunny

Was just checking. Thanks

[sunny_talwar]