Over vs Runs -- same sequence number for each group

I am having input column as runs with values
3
2
4
6
0
1
0
3
2
6
0
0
4
1
1
2
3
In output I want over number on Over column and corresponding runs on Runs column
Expected o/p is:-
Over Runs
1 2
1 4
1 6
1 3
1 0
1 1
2 0
2 3
2 2
2 6
2 0
2 0
3 4
3 1
3 1
3 2
3 3

Showing Answers 1 - 1 of 1 Answers

Amaan Ansari

  • Feb 5th, 2021
 

There are multiple ways to do it.
Simplest way is to use a reformat

Use a reformat

In the input
Record
Decimal (‘|’) Runs;
End

In the output dml
Runs
Over


In the transform 

Out.run :: in.run
Out.over :: decimal_rounddown((next_in_sequence/6) + 1,0)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions