Solved

Select Records in single table and add value to other field

  • 1 December 2022
  • 1 reply
  • 3 views
vxn43
Rank
Userlevel 1
Badge +15

I have a single table, TABLE1. I have a field named STE. I would like to select the values of STE that are NOT NULL, then add the selected values in STE to the ADDR field in same table.

 

What is the most suitable transformer(s) to go about doing this?

icon

Best answer by dustin 1 December 2022, 21:42

View original

1 reply

dustin
Rank
Userlevel 3
Badge +26

Several ways to accomplish, but I normally use an AttributeManager with a conditional value. The test condition will be testing SDE for not null, if so, set the attribute value to SDE. Otherwise, no action.

image

Reply


Community Stats

28,743
Posts
109,587
Replies
36,582
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.