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