000015987 - Archer Data Import Does Not Update Fields

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000015987
IssueUpdate calculated fields using a data import.
After running a data import, some fields do not appear to update.
CauseThe fields that were not updating were calculated fields. The source data had new text values for the fields, but when the calculated fields were calculated after the update, the values returned to the actual calculated value.
Resolution

To update the calculated fields, one should update the fields that were included in the calculation versus updating the actual calculation field itself. Example:

CalcField1 =

IF([Rating]>15,"A",?B?)

CalcField1 should not be updated in the source data. The Rating field in the calculation should be updated so that the calculation can determine the correct value based on the conditional statement.

Legacy Article IDa62209

Attachments

    Outcomes