I have an Org Unit set up of "ccHrComms" that I need to assign to the records coming in to this table:
Org Unit Setup
During the Load File process, I have defined another column to load the ccHrComms information in to and use throughout the workflow:
Main file load activity setting dataEven setting a default value
I have attempted a reconciliation step both by itself and in conjunction with targeting the rest of the data, that I am attempting to use to enrich the data with the Org Unit information:
Main reconciliation screen
Reconciliation matching Org Unit
I have noticed that after performing this activity, the Org Unit link still does not seem to be in the data during the transition - but I'm not sure if it should be or not.
At the Update Data activity, one of the fields I set is to update the Org Unit using the value from the Data Load activity:
Data Update activity linking incoming Org Unit name (from file load) to the Org Unit link
Unfortunately, no matter what I do, I always get the exact same error:
This error seems to occur whether I do the reconciliation step together with the RSU match step in the screenshot above or if I try to do it separately. Has anyone been able to successfully update the Org Unit at the same time as the data import? I'm open to any suggestions at this point to help me figure out what I'm doing wrong.