Create running number that always start from 1 until the end of row in word document

[adityo_reksopra]

What is the function to Create running number that always start from 1 until the end of row in word document

[TeeSee1]

You can use this technique (INDEXOF()) to derive sequential numbering and use it in your template like any other column.

<<COUNT(
  SPLIT(
    ANY(
      SPLIT(
        (“ , “ & [_THISROW].[Related cops] & “ , “),
        (“ , “ & [id column] & “ , “)
      )
    ),
    “ , “
  )
)>>

Embed it inside the existing <<START>><<End>> tags.

[adityo_reksopra]

Hi @TeeSee1 , thank you for your response, could you help me, where the code have to put inside of the <<Start>><<End>>?

Pers.No	Full Name	Date of Birth	Start Date	End Date	Loan Balance	Description	Start date Insurance	End date Insurance	Bank Penerima	Nomor Rekening	Nama Pemilik Rekening
<<Start:[Related cop penutupans]>><<[NRP_VC]>>	<<[Full Name_VC]>>	<<TEXT([Date of Birth_VC],”dd/mm/yyyy”)>>	<<TEXT([Start Date Loan_VC],”dd/mm/yyyy”)>>	<<TEXT([End Date Loan_VC],”dd/mm/yyyy”)>>	<<[Loan Balance_VC]>>	<<[Desc_VC]>>	<<TEXT([Start Period Insurance_VC],”dd/mm/yyyy”)>>	<<TEXT([End Date Insurance],”dd/mm/yyyy”)>>	<<[Bank Penerima]>>	<<[Nomor Rekening]>>	<<[Nama Pemilik Rekening]>> <<End>>

[adityo_reksopra]

Hi @TeeSee1, the output is like this, but what i need is like this

No

Pers.No

Full Name

Date of Birth

Start Date

End Date

Loan Balance

Description

Start date Insurance

End date Insurance

Bank Penerima

Nomor Rekening

Nama Pemilik Rekening

<<Start:[Related cop penutupans]>><<COUNT(SPLIT(ANY(SPLIT((","&[_THISROW].[Related cop penutupans]&","),(","&[Key]&","))),","))>>

<<[NRP_VC]>>

<<[Full Name_VC]>>

<<TEXT([Date of Birth_VC],”dd/mm/yyyy”)>>

<<TEXT([Start Date Loan_VC],”dd/mm/yyyy”)>>

<<TEXT([End Date Loan_VC],”dd/mm/yyyy”)>>

<<[Loan Balance_VC]>>

<<[Desc_VC]>>

<<TEXT([Start Period Insurance_VC],”dd/mm/yyyy”)>>

<<TEXT([End Date Insurance],”dd/mm/yyyy”)>>

<<[Bank Penerima]>>

<<[Nomor Rekening]>>

<<[Nama Pemilik Rekening]>> <<End>>

[TeeSee1 · Accepted solution]

Make sure there are spaces before and after the comma in " , " 

[adityo_reksopra]

Thank you! @TeeSee1 I've been working this whole week, and solved by you within minutes