how to fill a specific cell

[TonyMu]

Hello Guys, 

I have a very simple question, how do I fill a specific cell with a value? 

för example if I want to update cell " F11 " with value "12"

Regards, 

Tony

[Emil_Kos]

Hi @TonyMu,

I have used workflow from this post to make it work for you:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Write-a-specific-value-to-a-specific-c...

I believe this will work for you:

Good luck!

[DeanWest]

Hey Tony,

If you're asking how to fill a cell with Alteryx, consider the following procedure:

Use a RecordID tool to create a field to reference, then use a Formula Tool to change the value. Within the Formula Tool, you can reference the field/column that you want to update. In the provided example, I updated "B10".

Hopefully, this helps! Please let me know if you need any more help or assistance. 🙂

[TonyMu]

Hello Emil_Kos, 

Thanks for your reply, your solution works but I have a problem. 

my input is a excel file with headers, how do I extract a single cell with value from that data (by removing the headers?)  to generate somthing like what you have as input? 

Please see below for clarification 🙂 

I want to go from:

data

2.5

to 

2.5

from here I can your solution you already provided. 

Thanks in advance, 

Tony

[Emil_Kos]

Hi @TonyMu,

I think you need to choose start data import on line 2 in your input tool

Hope it helps!

[TonyMu]

Hello DeanWest, 

thanks for your reply, very interesting. 

actually what I want to do is to take a calcualted value I already have in another flow into a new excel file at a specific cell adress. 

as example I have something like this as input: 

Data
2.5
2.8
0.8
1.6
2.5
6,9
5

I want to extract the average value of this column and put it in cell B12 in another excel file I have in the same map (without the header following). 

Is that possible to fix in some way? 

Mvh, 

Arman 

[TonyMu]

Hi Emil_Kos, 

Thanks for very fast reply. 

the thing is I have a very large input file with lots of columns. I do some analysis ans matematical calculations to generate a value I want to copy later into another excel file, so I need the headers to begin with. 

after doing my calculations I would like to copy the results into specific cells in another excel file already existing. 

I afraid the solution you provided, not to import the headers from the begining, does not really work for me in this case, or? 

is there any way to extract a value from a data with headers? (as I shown in previous reply?)

Regards, 

Arman 

[Emil_Kos · Accepted solution]

Hi,

I have imported the headers but in the output file, I removed them. 

Input:

Output:

I skipped the filed names in the output:

I hope this time you will have all you need!

[Emil_Kos]

Hi @TonyMu,

Thank you for making my post as a solution!

Good luck with your projects!

[ilovecoding]

i wanted to reach to this paritcular total of my csv file. This cell may or may not be fixed in the source file. If i used recon id function then how i will tell alteryx to use this cell references to copy when cell reference chages.