Alteryx Designer Desktop Discussions

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

Output to Excel in one workflow and I want to write to multiple locations (cells).

SaoriYamguchi
8 - Asteroid
Output to Excel in one workflow.
At that time, I want to write to multiple locations (cells).
 
For example, A1 and B10 (A1 and B10, not A1 to B10)
How can I do it?
Thank you as always
4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@SaoriYamguchi 
From what I know, we can not update a single Cell, but we can update a whole column.

SaoriYamguchi
8 - Asteroid

Thank you very much.
Then we cannot write to multiple distant cells at the same time.
But if you do it, can you do it by creating a macro and repeating the process?
I think it's difficult because the place to write each time is different.

DawnDuong
13 - Pulsar
13 - Pulsar

Hi @SaoriYamguchi 

You can write specific data to specified cell references.

if you have more than one references, you need the “Block until done” tool because you cannot do concurrent writing to many instances of the same file.

dawn 

DawnDuong
13 - Pulsar
13 - Pulsar
Labels