We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Design Excel formula with a workflow

carrera
5 - Atom

Hello all,

I am trying to design an Excel formula with an Alteryx workflow:

 

carrera_0-1637206289525.png
carrera_1-1637206352706.png

I already have column D imported in Alteryx. I thought about the Multi-Row tool, which might be useful to work with. But I have only used the normal formula tool so far with very simple formulas. I am struggling with this one.

 

Does anyone know how to solve this with Alteryx?

1 REPLY 1
Pang_Hee_Choy
10 - Fireball

for most of the tool, it have an option to open example, you may try to open it. 

 

you can manipulate the config to understand how it work.

Pang_Hee_Choy_0-1637215646463.png

for your question, in multiple row tool, just simple replace

D49 with [D] and D48 with [Row-1:D] and E48 with [Row-1:E]

 

maybe you can explore formula, SWITCH 

Labels