Behavior:
When setting up an Assign Data activity to write to all columns of a Table field, you get the following error message when a document is run through the workflow.
When setting up an Assign Data activity to write to all columns of a Table field, you get the following error message when a document is run through the workflow.
"Error in system activity: [#: Destination Table Field: [TableField]] Invalid column name '[Value]'."
Solution:
When configuring the "Table" lookup settings for the entry portion of the Assign data step, the value we're looking for in our "WHERE clause" is most likely surrounded by double quotes."
For example, DW_COMPANY = "Peters Engineering" will return this error because when double quotes are used, this will be considered a column.
To address this issue, you'll need to use single quotes instead, such as the example below:
DW_COMPANY = 'Peters Engineering'
KBA applicable for both Cloud and On-premise Organizations
Solution:
When configuring the "Table" lookup settings for the entry portion of the Assign data step, the value we're looking for in our "WHERE clause" is most likely surrounded by double quotes."
For example, DW_COMPANY = "Peters Engineering" will return this error because when double quotes are used, this will be considered a column.
To address this issue, you'll need to use single quotes instead, such as the example below:
DW_COMPANY = 'Peters Engineering'
KBA applicable for both Cloud and On-premise Organizations
