Hi All,
I need to add a row to the existing table with the same values from another row
Thanks....
Solved! Go to Solution.
Hi @Raj008 , to do this I think you can simply filter out the row with the values you want, and then use the Union to add this row to the existing table. Hopefully that's what you're looking, if not maybe add a sample of your data.
Thanks Mark
Hi @Raj008
Depending on the quantity of columns, you can just use a multirow. Or if it is long, you can simply sample the last column and add it back to the workflow.
Pedro.
Hi pedrodrfaria,
My input is
Product Rate1 Rate2
Prime 1.2% 2.1%
I need the output as follows:
Product Rate1 Rate2
Prime 1.2% 2.1%
WPrime 1.2% 2.1%
Thanks for the help....
Hi @Raj008
This would be pretty easy using the WF I had provided as a solution for this case.
See attached for updated version using your example.