Skip to main content
Solved

Remove Table Qualifier for dynamic workspace

  • August 14, 2018
  • 3 replies
  • 148 views
oliver.morris
Contributor
Forum|alt.badge.img+14

Hi, I have a Schema Source and Destination in a database and the Feature Type names contain the Table Qualifier (e.g. <prefix>.<table_name>). One one side it is dbo. on the other it is tab.

I tried to follow the guide https://knowledge.safe.com/articles/1156/dynamic-workflow-tutorial-destination-schema-is-de-3.html but with this same data source you can remove the prefix as an option. With SQL Server it doesnt appear to be possible. How do you get round this?

Many Thanks,

Oliver

 

Best answer by oliver.morris

got it @ReplaceString(@Value(fme_feature_type),"dbo.","tab.",FALSE)

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.

3 replies

oliver.morris
Contributor
Forum|alt.badge.img+14
  • oliver.morrisContributor
  • Author
  • Contributor
  • 176 replies
  • Best Answer
  • August 14, 2018

got it @ReplaceString(@Value(fme_feature_type),"dbo.","tab.",FALSE)

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • August 14, 2018

You can use a StringReplacer to remove the schema name, something like:

0684Q00000ArLTAQA3.png

Text to replace:

(?:.+\.)?(.*)
oliver.morris
Contributor
Forum|alt.badge.img+14
  • oliver.morrisContributor
  • Author
  • Contributor
  • 176 replies
  • August 14, 2018

You can use a StringReplacer to remove the schema name, something like:

0684Q00000ArLTAQA3.png

Text to replace:

(?:.+\.)?(.*)
Thanks David

 

 

Community Stats

32,084
Posts
121,841
Replies
39,724
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.