Table Transformer doesn't work with numbering column

Question

As I can see Table Transformer doesn't work with numbering column.

If two table has numbering

then after merge two table result table has numeration as

1

2

1

2

Is there the workaround?

Andrey Khaneev _StiltSoft_ · Answer

Hi Artem,

You can use this SQL query:

SELECT *, ROWNUM() AS '_' FROM T*

It will replace the numbering column with a new correct one:

Kirstin Seidel-Gebert · Answer

Hi Artem,

can you remove the numbering from the merged table, and then apply a new numbering to the merged result?

Cheers,

Kirstin