Query Editor - Using query to form other data sets

[PGAT]

Hi, I’ve appended A to B, cleaned and transformed the data. Let’s call this table C. I am using C on one page. I do, however, need to use C to make two data set (D) and (E) for use on another page. Can I do this? It’s like taking the pivoted results of C to make D and E.

How can I use C to make D and E? Many thanks!


Sincerely,
Patrick

[Stachu · Accepted solution]

Right click query C and press Reference

it will create a new query where the first step will be query C

[PGAT]

Many thanks, Stachu!