Four Stars

cyclic sequence number generation based on multiple columns.

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!!

 

 

 

 

1 REPLY
Moderator

Re: cyclic sequence number generation based on multiple columns.

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.