Start Free Trial

Alteryx Designer Desktop Discussions

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

Help with multi-row formula for fill case using criteria

aden08
9 - Comet

Hi community, I need your help to solve this problem, is using multi-row formula using Found_Crit and Help_Field and Sec. As you see in the next picture I feel using 1 If de SEC is descending(3,2,1) If is 1 Is not neccesary fill.

4 REPLIES 4
binu_acs
21 - Polaris

@aden08 One way of doing this

image.png

aden08
9 - Comet

Thank u very much @binu_acs but I have a question, is not possible the same results using Round or Help_Field, that is because that 1 is a Criteria during the analysis so sometimes the Sec(4,3,2,1) exist but without 1 that accomplish that criteria.

binu_acs
21 - Polaris

@aden08 The expected result updating 1 or null based on the SEC value, but for the FOUND/Help field how would you do it manually? If you have any logic in your mind let me know I will try to implement that in the multi-row tool

aden08
9 - Comet

Yes bro thank you very much, your help to found principally the SEC using the Uniq values, help me to using antoher multi-row formula, only to have that accomplish the Criteria of ROUND=1. This difference discrept when exist any SEC without HELP_FIELD=1

 

Labels
Top Solution Authors