How To Fix RSAN_RT701 - Value &3 for transformation field &2 is not unique. Node: &1

RSAN_RT701 - Overview

• Message type: E = Error

• Message class: RSAN_RT - Messages for Runtime Analysis

• Message number: 701

• Message text: Value &3 for transformation field &2 is not unique. Node: &1

What causes this issue?

The transformation <LS>List by Data Record</> is used in node &V1&.
When this transformation is executed, the value &V3& occurs multiple
times in the source data for the transformation field &V2&.
When applied to the example in the
<DS:DE.RSAN_WB_DST_LIST_VEC>documentation for this node</>, this
corresponds to a question having been answered more than once in a
survey. If this data is to be summarized in a data record, only one
answer can be taken.

System Response

Since it is not clear which data record is the right one in this case,
processing of the analysis process is terminated.

How to fix this error?

Check the definition of the analysis process and make any necessary
changes. Define the analysis process appropriately to ensure that no
duplicate records arise. You can achieve this by using, for example, an
aggregation node in front of the current node to aggregate the data.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message RSAN_RT701 - Value &3 for transformation field &2 is not unique. Node: &1 ?

  The SAP error message RSAN_RT701 indicates that there is a problem with the transformation field in a data flow, specifically that the value for the transformation field is not unique. This typically occurs in the context of SAP BW (Business Warehouse) when dealing with data transformations and data loading processes.
  
  Cause:
  The error message RSAN_RT701 is triggered when the system encounters a situation where the value for a specific transformation field is expected to be unique, but it finds multiple records with the same value. This can happen due to:
  
  Duplicate Data: The source data contains duplicate entries for the transformation field.
  Incorrect Transformation Logic: The transformation rules defined in the data flow may not be correctly set up to ensure uniqueness.
  Data Model Issues: The data model may not be designed to enforce uniqueness for the transformation field.
  
  
  Solution:
  To resolve the RSAN_RT701 error, you can take the following steps:
  
  
  Check Source Data: 
  
  Review the source data