Skip to main content
  • EN

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

 

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

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

0684Q00000ArLTAQA3.png

Text to replace:

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

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

0684Q00000ArLTAQA3.png

Text to replace:

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

 

 

Reply


Community Stats

31,799
Posts
120,793
Replies
39,417
Members

Latest FME

Terms & ConditionsCookie settings
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.