Skip to main content
Question

Update/Insert specifical attribute


mr_fme
Enthusiast
Forum|alt.badge.img+8

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

2 replies

crutledge
Enthusiast
Forum|alt.badge.img+31
  • Enthusiast
  • March 23, 2025

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


mr_fme
Enthusiast
Forum|alt.badge.img+8
  • Author
  • Enthusiast
  • March 24, 2025

Follows attached


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings