Alteryx Designer Desktop Discussions

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

Simple multi row formula

Hamder83
11 - Bolide

Hi 

I wanna group my data, for each SEQ in column two i wanna assign a itteration number.

Hamder83_0-1630504107074.png



Thought I could do something like this. But im a little off 😕

Thanks in advance

7 REPLIES 7
atcodedog05
22 - Nova
22 - Nova

Hi @Hamder83 

 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

messi007
15 - Aurora
15 - Aurora

@Hamder83,

 

Could you share a sample data and what you expect to have.

It will help us to give you the solution.

 

Regards,

Hamder83
11 - Bolide

Sorry thought I had it attached. Its here 

atcodedog05
22 - Nova
22 - Nova

Hi @Hamder83 

 

Here is how you can do it.

Formula:

IF [SEQ]="SEQ" THEN [Row-1:Itter]+1 ELSE [Row-1:Itter] ENDIF

 

Workflow:

atcodedog05_0-1630504684998.png

 

Hope this helps : )

 

messi007
15 - Aurora
15 - Aurora

@Hamder83,

 

Please see below

 

messi007_0-1630504659595.png

 

Attached the workflow.

Regards

Hamder83
11 - Bolide

You guyes @messi007  and @atcodedog05  are geuiousses, thank for a quick reply! 🙂 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Hamder83 

Cheers and have a nice day!

Labels