Skip to main content

Hi,

 

I have one table that have attributes called months of the year, that begin in OUT_24, NOV_24...until SET_25.

My workspace will run month by month by workspace runner. In my workspace sometimes the value is filled in OUT_24, in the next execution NOV_24...until the end.

 

How my table can be updated if OUT_24 have a values only for example? I would like to ignore attributes with missing values.

 

I try this code in SQLExecutor: 

 

UPDATE ARCGIS.BTA_SAT_NDVI_pl SET MAR_25 = @Value(MAR_03) WHERE COD = @Value(COD) AND NEW_ID = @Value(NEW_ID);

 

But don’t work for me...because I need to change SQL after SET to attribute with value.

 

Thank´s

Hi ​@mr_fme Can you share the workbench/data?


Follows attached