Skip to main content
  • EN

Hello everyone,

 

I'm a beginner in FME and need some help. I'm trying to join (1:1) data from our datalake with an existing GIS layer. My goal is to append the result of this join nightly to another existing layer. I've attempted to use SQLExecutor to query multiple tables in the datalake and DatabaseJoiner to join the query table with the GIS layer, but it doesn't seem to be working.

 

Any suggestions or advice would be greatly appreciated. Thank you!

Can you elaborate what kind of database you have?

Both the datalake and the GIS db are MSSql.

 

I attached an image of my workflow. After exporting the GIS layer to an Esri file geodatabase, I used SQL creator for querying the datalake. Then, I attempted to use the FeatureJoiner to join the tabular data from the datalake to the file geodatabase layer. Unfortunately, the FeatureJoiner keeps failing and I'm encountering the following error.

 

FeatureJoiner_<Rejected> (TeeFactory): FeatureJoiner_<Rejected>: Termination Message: 'FeatureJoiner output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''

image

Both the datalake and the GIS db are MSSql.

 

I attached an image of my workflow. After exporting the GIS layer to an Esri file geodatabase, I used SQL creator for querying the datalake. Then, I attempted to use the FeatureJoiner to join the tabular data from the datalake to the file geodatabase layer. Unfortunately, the FeatureJoiner keeps failing and I'm encountering the following error.

 

FeatureJoiner_<Rejected> (TeeFactory): FeatureJoiner_<Rejected>: Termination Message: 'FeatureJoiner output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''

image

Hi @juneacosta​ What's the rejection message for the feature that was rejected? fme_rejection_message

If you turn on 'Continue Translation' in the Rejected Feature Handling do you get the desired result?

Reply


Community Stats

30,112
Posts
114,307
Replies
37,745
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.