I need to find the best way to change the name of a table that is referenced in some sql transformers
Question
I need to change the name of a table that is referenced in some sql transformers, what is the fastest and best way?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+18- Supporter
Hi,
I usually use the Workspace Search for find out where the name is present, open the transformer and copy the new value.
Hi,
I usually use the Workspace Search for find out where the name is present, open the transformer and copy the new value.
Hi Itay, thans for your answer
That way I need to search one by one, Is there a way to search globally?
+18- Supporter
Hi Itay, thans for your answer
That way I need to search one by one, Is there a way to search globally?
Not that I know of. You could open the workspace via Notepad and do a search and replace, but beware it can corrupt the workspace...
+40- Contributor
It probably won't help you in the immediate term, but I like to use private parameters for things like this that get referenced by multiple transformers. That way, when it needs to be updated, all you need to do is change the parameter value. Additionally if you right click on the parameter and select Show References, it will list all the transformers that reference that parameter.
+18- Supporter
It probably won't help you in the immediate term, but I like to use private parameters for things like this that get referenced by multiple transformers. That way, when it needs to be updated, all you need to do is change the parameter value. Additionally if you right click on the parameter and select Show References, it will list all the transformers that reference that parameter.
Totally agree @jdh