Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

how to fill a specific cell

TonyMu
8 - Asteroid

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

9 REPLIES 9
Emil_Kos
17 - Castor
17 - Castor

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:

 

Emil_Kos_0-1603038118652.png

 

Good luck!

DeanWest
9 - Comet

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".

DeanWest_0-1603064941869.png

 

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

 

TonyMu
8 - Asteroid

Hello 

 

 

 

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
17 - Castor
17 - Castor

Hi @TonyMu,

 

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

 

Emil_Kos_0-1603092282075.png

 

Hope it helps!

TonyMu
8 - Asteroid

Hello 

 

 

 

 

Data

2.5

2.8
0.8
1.6
2.5
6,9
5

 

 

 

TonyMu
8 - Asteroid

Hi 

 

 

 

 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

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

 

Input:

 

Emil_Kos_0-1603093720002.png

 

Output:

 

Emil_Kos_1-1603093743901.png

 

I skipped the filed names in the output:

 

Emil_Kos_2-1603093765638.png

 

 

I hope this time you will have all you need!

Emil_Kos
17 - Castor
17 - Castor

Hi @TonyMu,

 

Thank you for making my post as a solution!

 

Good luck with your projects!

ilovecoding
8 - Asteroid

ilovecoding_0-1678095301565.png

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.

Labels