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!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels