Preparation

[Vishvesh_2901]

I am trying to capture a single cell value from (e.g. A5) to 1. A new column for all rows 2. A specific cell (e.g. B5). Does anyone know the efficient way to do this via any tool?

[Luke_C · Accepted solution]

Hi @Vishvesh_2901 

You could isolate this value a variety of ways. I've seen this done with record ID + filtering if it'll be consistently in the same location, or the select records tool. Once you have the value isolated you would use the append fields tool to get it to repeat for all rows in your dataset in a new column.

For your second point, are talking about in your output? Again you'd isolate the value and have a specific output tool set to go to the range (cell) you want. 

[Vishvesh_2901]

That's interesting, I can try that. Thanks a Lot!