Behavior:
Have a workflow assign data step which performs a File Cabinet Lookup, and when we run through the workflow, we receive the error,
"Invalid column name 'Parameter' "
Solution:
When setting up the Where clause for a File Cabinet lookup and we're including Global Variables or Fixed entries in the statement, then it's important that we surround them with single quotes.
Examples:
DW_DOCUMENT_TYPE ="Invoice In" And DW_COMPANY_NAME = GV_Company_Name
This will throw the above error message because GV_Company_Name and "Invoice In" are not surrounded by single quotes.
Once entered like this;
DW_DOCUMENT_TYPE = 'Invoice In' And DW_COMPANY_NAME = 'GV_Company_Name'
This will work correctly since single quotes have been implemented and will allow the conditions to be read successfully without error.
KBA applicable for both Cloud and On-premise Organizations.
