Alteryx Designer Desktop Discussions

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

How to add a row to a file based on the existing row

Raj008
8 - Asteroid

Hi All,

 

I need to add a row to the existing table with the same values from another row

 

Thanks....

5 REPLIES 5
markcurry
12 - Quasar

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

pedrodrfaria
13 - Pulsar

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.

 

pedrodrfaria_0-1613077246438.png

 

 

Pedro.

Raj008
8 - Asteroid

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

 

ArtApa
Alteryx
Alteryx

Hi @Raj008 - Here it is:

ArtApa_0-1613086147242.png

 

pedrodrfaria
13 - Pulsar

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.

 

pedrodrfaria_0-1613095142631.png

 

Labels