I combined the data using data blending. I've almost 10 sheets which are using the same connection.
Now I want to swap the primary and secondary connections. Tableau does not allow me to do that unless and until I clear the entire view.
In the real time, requirements keep on changing. In future if I've 100 sheets, i'll have to rebuild all the views from the scratch.
How to swap primary and secondary connections once the views are built?
I'm afraid this is not possible within Tableau..
You will need to rebuild the views from scratch.
The only thing you can try is the following one:
If this does not work, you have no other option than rebuilding.