Question

How to search for just part of FME Feature attribute name?

  • 12 December 2016
  • 3 replies
  • 2 views
N

I have exposed the fme_feature_type attribute.

I am then using the FeatureWriter to write this feature class (FGDB) to POSTGIS.

Its new name in POSTGIS is @LowerCase(@Value(fme_feature_type))_load.

My next transformer is the SQLExecutor where I am trying to find if the above table already exists but doesn't have the _load at the end and DROP that table if it does exist

So for example. I am loading Cities_load but want to drop the existing Cities table if it exists and then RENAME the Cities_load to Cities.

What would my SQLExecutor read?

DROP TABLE IF EXISTS @ReplaceString(@Value(_feature_type{0}.name), '_load', ''); ALTER TABLE @Value(_feature_type{0}.name) RENAME TO @ReplaceString(@Value(_feature_type{0}.name), '_load', '');

The above SQL doesn't seem to work correctly...

 

3 replies

erik_jan
Rank
Userlevel 2
Badge +12

I would create a new attribute (DROP_TABLE), copy the value of fme_feature_type in that attribute and then use the StringReplacer to replace "_load" with nothing. Then use that attribute in the SQL statement avoiding the functions in the statement.

erik_jan
Rank
Userlevel 2
Badge +12

Or use the SubstringExtractor as shown in the image (replace Test_load with attribute containing table name and result attribute to be DROP_TABLE):

N

Or use the SubstringExtractor as shown in the image (replace Test_load with attribute containing table name and result attribute to be DROP_TABLE):

@erik_jan, I can tell that the correct renaming is occurring by looking at the logfile. Thanks for the SubStringExtractor tip.

 

 

but I am still getting this error.

 

 

Error executing SQL command ('ALTER TABLE energy_land_northamerica.cities_load

 

RENAME TO energy_land_northamerica.cities'): 'ERROR: syntax error at or near "."

 

LINE 2: RENAME TO energy_land_northamerica.cities...

 

^

 

'

 

A fatal error has occurred. Check the logfile above for details

 

 

 

Reply


Community Stats

28,670
Posts
109,365
Replies
36,531
Members
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.