Forum Discussion
Zain26
8 years agoAdvocate II
Change Data Source for Table
Hi guys, I want to change the data source of my existing tables. Currently I have 4 tables A,B,C,D which I use in my report. Each of these tables is created by appending 10 csv files. For Example: T...
MattAllington
8 years agoCommunity Champion
The best way I have found (and best way to learn) is to create a new query to the data in its new location. Then go into the advanced editor and cut the code. Then go into the original query, paste the code at the top, and then delete the old source lines of code leaving just he new ones. See how you go. Each line of code normally refers to the previous line of code in the first parameter. So as long as you get those right, you should be fine
Zain26
8 years agoAdvocate II
Can you elaborate this with some example.
- Eric_Zhang8 years agoMicrosoft Employee
Zain26 wrote:
Can you elaborate this with some example.
In advanced editor, you just replace the hightlighted part from csv query with the highlight part from SQL Server.