Copy and paste - from specific cell to specific cell - without any commonalities

[ilovecoding]

Hi Team,

I'm looking for solution to below. I want to copy and paste the highlighted value in highlighted cell. How can i do it on alteryx?  

[Yoshiro_Fujimori · Accepted solution]

@ilovecoding , 

Unlike Excel, I do not need to care so much about the cell number.

But when I have to do so, I would add Row number to specify which cell to update, and then "Transpose" to locate the value easily.

Say I want to copy the value in [C4] of the input table to [D5] of the output table,

Input

Output table before run

Output table after run

Does it work for your case?

[ilovecoding]

Almost there, but what if the cell which i am copying from is going to be the last cell and designer wouldnt know what cell number is that going to be as it may or may not change. 

[Yoshiro_Fujimori]

To add records after the last row, I would use Union tool.

Tool Mastery page below may help.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Union/ta-p/32872