How to select specific tables in table transformer

Question

If I have 3 tables in my table transformer and I want to select all columns from all tables the syntax is

select * from T*

. What would be the syntax if I wanted to select all columns only from table 2 and Table 3 as if I had only these two tables in my table transformer but still having all three tables in it?

Stiltsoft support · Answer

Yeah, the portal is confidential, you'll be able to share the source tables and the desired outcome, and we'll try to come up with a possible solution.

Besides, there all the questions are registered and here we try to find the related questions manually, so maybe smth is lost.

Alexandra Kühn_puzlnw · Answer

Thanks for mentioning your support portal. I will contact them then. I already tried the syntax you suggested but that doesn't give the right result.

Stiltsoft support · Answer

Hi @Alexandra Kühn ,

As you've mentioned the Table Transformer macro, we suppose that you are talking about our Table Filter, Charts & Spreadsheets for Confluence app.

If this is the case, please reach to our support portal directly: you'll be able to share more details and we'll be able to guide you.

Meanwhile, you may refer to the required tables using a comma separated list:

SELECT * FROM T2, T3