AutoNumber 1-4

[fosterma]

Hello, hopefully a quick one

I have a range of values that I want to autonumber from 1-4 in sequence, without a dimension to group the values. 

For Example:
1111,1
1112.2
1113,3
1114,4
1115,1
1116,2
1117,3
1118,4
1119,1

[treysmithdev · Accepted solution]

Would something like this fit your use case?

data:
Load 
    RowNo() as Row,
    Id,
    Replace(Mod(RowNo(),4),'0','4') as FormulaA,
    Mod(RowNo()-1,4)+1 as FormulaB,
    Goal
Inline [
    Id, Goal
    1111,1
    1112,2
    1113,3
    1114,4
    1115,1
    1116,2
    1117,3
    1118,4
    1119,1
];

Output:

[fosterma]

Perfect Thanks @treysmithdev