Hello everyone, I have problems creating some type of cycles or loops with alteryx,
in the column "Fecha" as seen there is a date format and another that represents an account number,
I would like to associate each policy in another column with its corresponding account,
to later delete the row that has the account, e.g. 410001.1
I would appreciate your help, thank you
Solved! Go to Solution.
Hi @Hannia_Ruíz. Welcome to the Alteryx Community. I am moving your post to our Designer Discussions board so you have more visibility.
Also, I noticed that you are using your Designer in Spanish. Have you checked our Spanish Community? There you can not only find resources in Spanish but Alteryx users that can help you in your native language as well. 😉
Saludos!
Hi @Hannia_Ruíz
You can use a formula tool to create the column CN that says
If [Prueba] = 0
THEN [Fecha]
ELSE Null()
ENDIF
Then you can use a multi row formula afterwards to update the CN column that says
IF IsNull([CN])
THEN [Row-1:CN]
ELSE [CN]
ENDIF
This will fill down the CN to every row below it until it hits the next CN. Then you can use a filter that says
[Prueba] != 0
Thank you so much!
Cheers from Mexico 😄