Forum Discussion

Matjo's avatar
Matjo
Icon for Advocate I rankAdvocate 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
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
Icon for Community Champion rankCommunity 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?