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 1 | Price1 | Price2 |
NA | 10 | 11.5 |
NA | 12 | 13.5 |
NA | 15 | 16.5 |
NA | 18 | 19.5 |
NA | 18 | 19.5 |
NA | 20 | 21.5 |
Output
Set 1 | Price1 | Price2 |
1 | 10 | 11.5 |
1 | 12 | 13.5 |
1 | 15 | 16.5 |
1 | 18 | 19.5 |
1 | 18 | 19.5 |
1 | 20 | 21.5 |
2 | 10 | 11.5 |
2 | 12 | 13.5 |
2 | 15 | 16.5 |
2 | 18 | 19.5 |
2 | 18 | 19.5 |
2 | 20 | 21.5 |
Solved! Go to Solution.
Hi @Naga ,
Using the Append tool and text tool you can achieve this.
Check the shared workflow for reference.
Regards,
Venkatesh
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
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.
Regards,
Venkatesh
Thanks much appreciate it...:)