Hey everyone
I have a model in dev that is currently pointing to connection A, I need to repoint all the import layer queries to connection B but I can't chaneg connection A in the portal because there are other models using it.
I've added connection B in the portal and as a data source in my model. Querstion is; does anyone know of a quick way of updating all the import layer query subjects to point to the new data source?
I could manually go through the queries and change them but there are more than 2k queries?
As always any help appreciated
Simon
Back up your cpf file and open it up in notepad and do a find and replace on your data source.
Maybe you open the Model file in an text editor and do a "search&replace"?
Both - thanks for your help that was a whole lot easier than I thought it was going to be :)