Skip to main content

When using a SQLCreator or Creator, I can't get the VariableRetriever to attach attributes to the created data. It works correctly with any other data but not the creator(s).

 

Can anyone else replicate this behavior?

FME 2020.1.0.0 (20200305 - Build 20510 - WIN64)

 

 

Works correctly with a shapefile input

 

_value is left null for the creator and SQLCreator records

It's probably an issue with the order of the features. Try setting a breakpoint on the incoming connection for all the Variable* transformers, execute the workspace and check where the execution stops first. If it isn't on the VariableSetter, that could explain the issue.

Try also setting "Create at end" = Yes on the Creator.


It's probably an issue with the order of the features. Try setting a breakpoint on the incoming connection for all the Variable* transformers, execute the workspace and check where the execution stops first. If it isn't on the VariableSetter, that could explain the issue.

Try also setting "Create at end" = Yes on the Creator.

Adding a sorter for any attribute corrected both of the issues.

 

Thank you kindly!


Reply