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.

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

Cheers!!

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.

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.