Forum Discussion
Create a new query from other table
Hello
I need to launch a query to another database with the data obtained in another table.
Example:
1) Fill with SQL the Data Table
2) Create a new Table with column customer
Now I neeed to create a SQL query to another database and server with Customer in (COLUMN) the only idea the only idea I can think of is to pass it to ',' join. And then pass it as a parameter in an SQL IN
'9556','288'
Is there any other way?
Can you help me make a ',' and pass it by parameter?
I can't do a merge query since there is a lot of data
Thanks
I found the solution here
Thanks
6 Replies
- mwegenerMost Valuable Professional
Hi sebasjuniper1,
I would recommend Power Query.
I think, if the Power Query Query Folding is not able to combine the data on Source Layer, there will be no better way.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
- sebasjuniper1Regular Visitor
Hi mwegener
Thanks for you reply
I don't understand why you tell me to use power query. What do you mean?
Thanks
- sebasjuniper1Regular Visitor
I found the solution here
Thanks