Solved

How update a column in a table with Variable Setter- Variable Retriever ?


Hi community!

 

I would like update a column in my table with a variable.

 

For that, I put in a VariableSetter my value that I retrieve after a Tester and with a VariableRetriver I recall my variable, and I want to insert this value of this variable in all the lines of my Code_Comma column.

But it's doesn't work.

Capture d’écran 2023-03-28 154641Someone can help me please ? Thanks

 

 

 

 

icon

Best answer by dustin 28 March 2023, 16:12

View original

3 replies

Userlevel 6
Badge +32

Two things about VariableSetters and Retrievers:

  • They do not always work well combined with FeatureCaching.
  • If you are using them, you need to make sure the setter is run before the retriever.

 

Another way to do this is to use a FeatureMerger, where you set the requestor and the supplier values to "1" instead of a value. This will add the attribute(s) of the lower stream to the features of the upper stream.

Userlevel 3
Badge +26

Instead of VariableSetter/Retriever, use a FeatureMerger instead. The 4 features would be fed to the Requestor port, and the single feature (where you would create your Code_Comma attribute), feed to the Supplier port. In the FeatureMerger, type '1' for Requestor and '1' for the Supplier. This will essentially force the Code_Comma attribute onto the 4 features.

thank you @nielsgerrits​ and @dustin​ !

 

Reply