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