Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
So, 'if' statement would not work here right?
Don't think so...
Thanks a lot sunny
Was just checking. Thanks