Reader: MSSQL_ADO
Writer: Esri File GDB Feature class
Transformer: AttributeManager
I am trying to see if I can first set a Where Clause to check if two fields (one from the SQL table and one field from Feature class) match each other. Once this is checked I want to update three other fields in the feature class using the information in the SQL Table
Here is how I have it setup right now
@zemd23 I think the problem is the Set Value in your AttributeManager - this would set the values of umc_prop_class... to "empty" since you have no value in the Attribute Value column. Try using "do nothing".
To update only the fields read form the SQL Server database follow the instructions in the article Updating Individual Fields of a Record to only update the fields that come from your SQL Server database
@zemd23 I think the problem is the Set Value in your AttributeManager - this would set the values of umc_prop_class... to "empty" since you have no value in the Attribute Value column. Try using "do nothing".
To update only the fields read form the SQL Server database follow the instructions in the article Updating Individual Fields of a Record to only update the fields that come from your SQL Server database
@markatsafe Thank you for the response. The issue is that it does not like my where clause. The SQL database has a field called bd_id and the Feature class has a field called BUILDINGNUMBER. So my goal is to first see if these two attributes match, and if they do match then we want to update two other fields.
The other article you pointed me to seems to update the same database table, I am looking to update the feature class based on the sql tables information. My where clause is currently setup on the feature class as "BUILDINGNUMBER"=@Value(bd_id)
Kindly let me know what you think I am doing wrong.
I was able to resolve the issue using the following transformers.
