I have multiple pages in Confluence, each with the same table with different content. I want to collect all these tables into one table. This works. Now I want to add the name of the pages into the first column. This works. But, this column is called pages. I want it to be called Projects.
The underlying table might be expanded and therefore I do not know which nor how many columns the tables have. That is the reason why I use T1.*. I need all that columns that are there, but I want to leave out the Page column.
I am using the Table Transform, which enables me to write a SQL script. The SQL syntax is ALASQl.
I tried the following, which gives another column called Projekt:
SELECT T1.'Page'AS Projekt, T1.* FROM T
But how do I remove column Page?
There is no rename in asasql in confluence.