Copy Range and Sort

[V834131]

Hi, need some help. I'm new to Alteryx, trying to build one for efficiency projects. 

I have an output file wherein i want to copy from row 2 up to the last row (column A to F, row1 as header) and paste it below the last row of the same sheet. Then, replace cell value of column F as "Non-Algo". I'm getting a "0" value on column F instead. 

Afterwards, sort A to Ascending and F to Descending. 

[Sebastian_Chaieb2]

Hi @V834131 

Could you attached a sample of data? or screenshot? also it would be good if you can attached a screen with an example of expected results.

Best regards,
Sebastian  

[Yoshiro_Fujimori · Accepted solution]

Hi @V834131 ,

Is this what you mean?

When you input data to Alteryx, you can use the first row as the column name (usually by default).

So you can simply copy all the "data rows" and append them to the original table with Union Tool.

I am not sure how you get "0" value, but you can simply replace the data with Formula Tool as above.

I hope this helps. Good luck.