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

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?

Datasets

Accepted answers

Yoshiro_Fujimori

@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?

SetValueFromAnyCellToAnyCell.yxmd

All comments

Yoshiro_Fujimori

@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?

SetValueFromAnyCellToAnyCell.yxmd

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.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280