cyclic sequence number generation based on multiple columns.

[Anonymous]

Hi All,

I need help with generating cyclic sequence based on range of columns. 

Provided below is sample data.

order_no	Code_1	Code_2	Input_Volume	Output_volume	Output_volume2
101	2001	1001	2000	4000
101	2001	2001	1000
101	2001	2002			3000

This is the input and i would need output as below.

Order_no	Input_1	In_Vol_1	Input_2	In_Vol_2	Output_1	Out_Vol_1	Output_2	Out_Vol_2
101	1001	2000	2001	1000	2001	4000	2002	3000

I'm trying to generate cyclic sequence_1 for the first 4 columns and second on 2nd,3rd and 4th columns.

That way i can identify the columns and data.

Please suggest alternatives, if any. 

And also help me create cyclic sequence based on combination of columns.

Cheers!!

[Anonymous]

Hello,

---

@Lucifer_18 wrote:

Hi All,

I need help with generating cyclic sequence based on range of columns. 

Provided below is sample data.

order_no	Code_1	Code_2	Input_Volume	Output_volume	Output_volume2
101	2001	1001	2000	4000
101	2001	2001	1000
101	2001	2002			3000

This is the input and i would need output as below.

Order_no	Input_1	In_Vol_1	Input_2	In_Vol_2	Output_1	Out_Vol_1	Output_2	Out_Vol_2
101	1001	2000	2001	1000	2001	4000	2002	3000

I'm trying to generate cyclic sequence_1 for the first 4 columns and second on 2nd,3rd and 4th columns.

That way i can identify the columns and data.

Please suggest alternatives, if any. 

And also help me create cyclic sequence based on combination of columns.

Cheers!!

---

Could you explain your cyclic sequence more specifc? It's not very clear for us. Thanks for your time.

Best regards

Sabrina