Forum Discussion

Matjo's avatar
Matjo
Advocate I
8 years ago
Solved

Transform multiple queries at once

Hi,  I have 60 queries for different tables. I want to apply the function Table.FirstN to all of them.  I tried selecting all and using the function Keep Rows but it only affected one query.  Is...
Need Help
ImkeF's avatar
ImkeF
Community Champion
7 years ago

Not with this additional transformation, unfortunatly.

The only way to create one query per table is through the steps via the manual UI where you click each table and one query will be created for each of them.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

what if there's no transformation? i.e. is there a way to bring all the tables from the db into different pquery queries?

  • ImkeF's avatar
    ImkeF
    Community Champion
    7 years ago

    Yes, if you import from SQL-Server for example, you will be presented a UI like this:

     

     

    for every table or view you check here, a seperate query will be created.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thanks ImkeF. what if i don't wanna select them manually? is there a way to write a script that'll do that for me?