Loading

Fields Become Invalid And Have '(1') Appended to Their Names When Using 'Replace Data Source'

Publiceringsdatum: May 30, 2025
Beskrivning

When using 'Replace Data Source', some fields may become invalid and also have '(1)' appended to their names. For example, [User ID] becomes [User ID (1)].

Cause

In order for 'Replace Data Source' to work, in addition to having the same field names in the workbook (not the remote column names), the data roles of the field (e.g. Discrete Dimension, Continuous Measure) have to be the same as well.
Lösning
In addition to having the same field names in the workbook (not the remote column names), ensure that the data roles of the fields (such as Discrete Dimension or Continuous Measure) are the same as well.
Ytterligare resurser
The 'Describe' option (in the field's context menu in the Data pane) can be used to get the details of a field in each data source. For more information, see Get Details About Fields and Sheets in a Workbook.

For more information about converting a measure to a dimension, see this document.
Knowledge-artikelnummer

001498214

 
Laddar
Salesforce Help | Article