Skip to main content
Question

Update/Insert specifical attribute

  • March 23, 2025
  • 2 replies
  • 46 views

mr_fme
Enthusiast
Forum|alt.badge.img+9

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
Influencer
Forum|alt.badge.img+43
  • Influencer
  • March 23, 2025

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


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

Follows attached