Table Transformer doesn't work with numbering column

[Artem Grusha]

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?

[Kirstin Seidel-Gebert]

Hi Artem,

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

Cheers,

Kirstin

[Andrey Khaneev _StiltSoft_]

Hi Artem,

You can use this SQL query:

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

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