community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Replicate the data set

Asteroid

Hi All,

 

Please help. I have a data set like below and I want that to convert to a data set like mentioned below.

 

 Input

Set 1Price1Price2
NA1011.5
NA1213.5
NA1516.5
NA1819.5
NA1819.5
NA2021.5

 

Output

Set 1Price1Price2
11011.5
11213.5
11516.5
11819.5
11819.5
12021.5
21011.5
21213.5
21516.5
21819.5
21819.5
22021.5

 

Meteor

Hi @Naga ,

 

Using the Append tool and text tool you can achieve this.

 

Check the shared workflow for reference.

 

 

Regards,

Venkatesh

Asteroid

Thanks @Venkatesh23 for your quick help. I got the flow and the approach to follow, however, it has no data linked. Can you share with data that should be helpful.

 

Thanks
Naga

Meteor

@Naga 

 

I have used the Text Input tool which is manually entered the values in the tool. You can use Instead of the Text input tool replace the required dataset for the input data tool. Connect (Input data tool) the S-> symbol of the Append tool and for the T-> symbol add the text input tool to duplicate the records how many times you want to repeat.

clipboard_image_0.png

 

Regards,

Venkatesh

Asteroid

Thanks much appreciate it...:)

Labels