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
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!
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-cell-in-a-specific-sheet-in/m-p/179800/highlight/true#M46468
I believe this will work for you:
Good luck!
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. 🙂
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:
to
from here I can your solution you already provided.
Thanks in advance,
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:
2.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
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.
