Skip to main content
Solved

Remove Table Qualifier for dynamic workspace

oliver.morris
Contributor
Forum|alt.badge.img+12

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)

View original
Did this help you find an answer to your question?

3 replies

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

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

david_r
Evangelist
  • david_rEvangelist
  • 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+12
  • oliver.morrisContributor
  • Author
  • Contributor
  • August 14, 2018
david_r wrote:

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

0684Q00000ArLTAQA3.png

Text to replace:

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

 

 

Reply


Helpful Members This Week

Community Stats

30,921
Posts
117,181
Replies
38,725
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.