community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Creating a new column based on RecordID

Meteor

Hello,

 

I have 16 record IDs, and I am looking to create a new column (RecordID2) that groups every 4 IDs. For instance:

RecordID 1 through 4 = RecordID2 1

RecordID 5 through 8 = RecordID2 2

RecordID 9 through 12 = RecordID2 3

etc. 

 

The data set will be a running data set with the most recent date as RecordID 1 and each week a new RecordID will be generated. So the data set will not always have Record IDs in multiples of 4. I am looking to automate this so the workflow can run indefinitely and not need a tweak to an IF formula at a later point in time. 

Highlighted
Alteryx Partner

I think the CEIL function is what you're after :

 

CEIL(x/4)

 

like this ...

 

Capture.PNG

Labels