Insert numbering Column in Table Filter and Charts for Confluence

[Carina Elles]

Hello,

I have at questions about the insert numbering column.

Can we delete the numbers without deleting the cell so that the numbering still continues?

Can we also start with a number other than 1?

Is it possible?

best regards

Carina

[Katerina Kovriga {Stiltsoft}]

Hi @Carina Elles ,

The first part of your case is not possible - the Table Filter macro allows you to set static/dynamic automatic row numbering (it will be updated automatically after you insert/delete the table rows). You may read about the available options here.

If you want to manually delete the numbers, change them, add letters, etc., it is better to create and maintain an additional column manually.

The second part of the case - start with a number other than 1 - is possible with the help of the Table Transformer macro.

SELECT ('Number' + 2) AS 'Number', 'Key', 'Summary' FROM (
SELECT ROWNUM() as 'Number', T1.'Key', T1.'Summary' FROM T1)

Here +2 means that we start with the number 3.

Hope this may help your case.

[Carina Elles]

Hello @Katerina Kovriga {Stiltsoft}

thank you very much for your answer. It helped our colleagues a lot.

best regards
Carina