Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Replicate the data set

Naga
8 - 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

 

4 REPLIES 4
Venkatesh23
7 - Meteor

Hi @Naga ,

 

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

 

Check the shared workflow for reference.

 

 

Regards,

Venkatesh

Naga
8 - 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

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

Naga
8 - Asteroid

Thanks much appreciate it...:)

Labels