Forum Discussion
Changing data source without effecting all query steps
There are a few ways to do this.
One way would be to connect to your new source until you're at the same point where your previous query's navigation steps ended and the transformations on top of the data began. They paste the follow-on steps from your old query into the Advanced Editor of the new query.
Another approach would be to use Extract Previous Steps on your old query (MyQuery) so that the part that's changing is extracted into a separate query (OldSource). Then create a new query (NewSource) that mimics what the extracted query (OldSource) did, but using the new source. Finally, point the first step of MyQuery at NewSource instead of OldSource.
There are a few ways to do this.
One way would be to connect to your new source until you're at the same point where your previous query's navigation steps ended and the transformations on top of the data began. They paste the follow-on steps from your old query into the Advanced Editor of the new query.
Another approach would be to use Extract Previous Steps on your old query (MyQuery) so that the part that's changing is extracted into a separate query (OldSource). Then create a new query (NewSource) that mimics what the extracted query (OldSource) did, but using the new source. Finally, point the first step of MyQuery at NewSource instead of OldSource.