Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Multi Row Formula Multi-Conditional Statement

D_Constantine
5 - Atom

I don't think that the multi-row formula should be that difficult to put together but I'm a little stuck.  Below is what the data looks like now.  

 

C1C2C3C4C5
InternalSYSTEM FOR ESTIMATINGA103220919-175Brooklyn
InternalSYSTEM FOR DEPTHA103330919-176Brooklyn
ExternalSYSTEM FOR DEPTHB102230919-215Brooklyn
Internal B114580919-177 
InternalGarmentsC204590919-178Pittsburgh
InternalUSING garmentsC205620919-179Pittsburgh
InternalUSING garmentsC205620919-180Pittsburgh
External C205620919-211 

 

I would like the blank spaces in [C2] and [C5] to fill what is above it, only if the letter/number combination in [C3] agrees to the one above it.  If it does not, I would like the cell to stay blank.  I'm getting lost writing my formula because of the dependency for [C2] blank cell and [C3] same row as blank cell has to equal C3 row above blank cell.  This is what I put together so far.

 

IF IsEmpty([C2]) AND [C3]=??????
THEN [Row-1:C2]
ELSE [C2]
ENDIF

 

This is what the outcome should be.  

C1C2C3C4C5
InternalSYSTEM FOR ESTIMATINGA103220919-175Brooklyn
InternalSYSTEM FOR DEPTHA103330919-176Brooklyn
ExternalSYSTEM FOR DEPTHB102230919-215Brooklyn
Internal B114580919-177 
InternalGarmentsC204590919-178Pittsburgh
InternalUSING garmentsC205620919-179Pittsburgh
InternalUSING garmentsC205620919-180Pittsburgh
ExternalUSING garmentsC205620919-211Pittsburgh

 

Thanks for your help!

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @D_Constantine 

 

See WF attached. 2 Multi-Row Formulas should do the trick.

 

2MultiRow.PNG

 

Cheers,

D_Constantine
5 - Atom

Thanks so much @Thableaus!  Worked for me!

Labels