Add Rows in a Dataset Recipe with Append
- On the dataset recipe page, click the Append Data button ().
- Select either the Published or Replicated tab, and click the dataset that you want to add. In our example, you would select the Opportunity dataset from the CanadaOrgconnection.
- On the map fields dialog, review how Analytics has mapped the recipe fields in the first column to fields from the data to append in the second column. Remember, fields with the same name and type are mapped automatically.Note By default, hidden fields in your recipe aren’t mapped. To map hidden fields, clickthe Show hidden fields link and accept or change themappings.
- To change a field mapping, click the field in the FIELD TO APPEND column, and select a field. You can only select from fields of the same type as the recipe field that you’re mapping to.In our example, you don’t have a field to map to the Lead Source field, so you leave that as it is. The Amount field has not been mapped because the corresponding field in the Canada data was named Value. So you map the Value field to the Amount field.
- When you finish mapping fields, click Continue.
- On the confirmation message, click Append.Note Rows that you append in a recipe do not appear in the recipe preview, but are addedto the target dataset when you run the recipe.