+2Hello 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!
+2Both 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''
+20Both 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''
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
