Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Group every N record

ayx-droid
7 - Meteor

Here's a problem I'm trying to solve where I need to allocate each 7 Ticket_ID's to a group and need to loop it through the incoming records. I've to use multi-row formula and tile but I was not successful in creating output below.

Output Expected:

Ticket_IDGroup
REQ0011
REQ0021
REQ0031
REQ0041
REQ0051
REQ0061
REQ0071
REQ0082
REQ0092
REQ0102
REQ0112
REQ0122
REQ0132
REQ0142
REQ0153
REQ0163
REQ0173
REQ0183
REQ0193
REQ0203

 

5 REPLIES 5
JohnJPS
15 - Aurora

Hi @ayx-droid,

 

For this, I would add a RecordID, and then a Formula assigning [Group] to be

 

CEIL([RecordID]/7)

 

Hope that helps!

John

ayx-droid
7 - Meteor

Thanks. It worked @JohnJPS . I've added a new column Link for category. And here's the expected output:

 

LinkTicket_IDGroup
AREQ0011
AREQ0021
AREQ0031
AREQ0041
AREQ0051
AREQ0061
AREQ0071
BREQ0082
BREQ0092
BREQ0102
BREQ0112
BREQ0122
BREQ0132
BREQ0142
BREQ0153
BREQ0163
BREQ0173
BREQ0183
BREQ0193
BREQ0203

 

How I can categorize the data using Link column?

danilang
19 - Altair
19 - Altair

Hi @ayx-droid 

 

What do you mean by "Categorize the data".  A sample output table would be the best description, avoiding any language induced ambiguity.

 

Dan

ayx-droid
7 - Meteor

@danilang I haven't updated my last post and haven't been thorough enough to explain how the changes for this post has gone through. Now, I've updated the post with my initial problem and it's subsequent changes. I've updated the expected outcome in my previous reply to @JohnJPS .

danilang
19 - Altair
19 - Altair

@ayx-droid 

 

By Categorize do you mean that you want the groups to restart at 1 when then Link changes?  i.e. A would have group 1 and B would have Group 1 and Group 2.

 

If the outcome that you've posted, A has group 1 and B has Group 2 and Group 3,  is what you're looking for, @JohnJPS's formula still works.

 

If @JohnJPS's solution is correct, then consider marking the solution as accepted.

 

Dan

 

 

Labels