How to make loops with Alteryx?, help

Question

Hello everyone, I have problems creating some type of 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

polizas.xlsx

Try_pol.yxmd

BrandonB · Answer

Try_pol v2.yxmd

BrandonB · Answer

Hi @Hannia_Ruíz

I commented on your other post as well, but here is the solution:

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