cyclic sequence number generation based on multiple columns.

Anonymous — Thu, 17 May 2018 08:45:04 GMT

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

Re: cyclic sequence number generation based on multiple columns.

Anonymous — Thu, 24 May 2018 10:15:24 GMT

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

topic Re: cyclic sequence number generation based on multiple columns. in Talend Studio

cyclic sequence number generation based on multiple columns.

Re: cyclic sequence number generation based on multiple columns.