Create iterative numbers

[X01330132]

Hello,

I am trying to achieve Field2;

Field1  Field2

1            1

2            1

3            1

1            2

2            2

3            2

1           3

2           3

3           3

I tried peek function as well as loops but I couldn't success. I am trying to create page numbers for NPrinting PowerPoint so the tables will fit accordingly.

Thank you!

[X01330132]

Hello,

I am trying to achieve Field2;

Field1  Field2

1            1

2            1

3            1

1            2

2            2

3            2

1           3

2           3

3           3

I tried peek function as well as loops but I couldn't success. I am trying to create page numbers for NPrinting PowerPoint so the tables will fit accordingly.

Thank you!

[jyothish8807 · Accepted solution]

Hi @X01330132 ,

May be like this this ?

T1:
load *,
RowNo() as SiNo,
if(Field1<>previous(previous(previous(Field1))),1,if(Field1=peek(Field1,-3),peek(Field2,-3)+1)) as Field2;
Load * Inline [
Field1
1,
2,
3,
1,
2,
3,
1,
2,
3
];

[X01330132]

Worked like a charm, thanks a lot 🙂

[Saravanan_Desingh · Accepted solution]

Try this,

tab1:
Load RowNo() As RowID,*,AutoNumber(RowNo(), Field1) As Field2 Inline [
Field1
1
2
3
1
2
3
1
2
3
];

[X01330132]

Also works great, thank you!