---
schema_version: "1"
id: c7da6322ad56789f8e20f73931da63fdde9086c8d4420d980366d53d9eba0861
title: MDP Total Rows Transformers
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_streams_tc_transformers_totals.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_streams_tc_transformers_totals.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1ab6e36764ac5d2c6db8fedb9cbfd8f087e82023f020e3a309cc178eb5488734
description: Use the total rows transformer when you want to change the default behavior of Marketing Cloud Intelligence Data Pipelines to strip out “totals” rows from all files. For example, if a file has non-additive measurements, and you want only the totals row mapped, use this transformer.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# MDP Total Rows Transformers

Use the total rows transformer when you want to change the default behavior of Marketing Cloud Intelligence Data Pipelines to strip out “totals” rows from all files. For example, if a file has non-additive measurements, and you want only the totals row mapped, use this transformer.

1. Navigate to the **Import** tab.
2. Expand **Data Streams List**.
3. Create a data stream, or edit an existing one.
4. In the **Preview Source** screen, click **Edit Transformers**. File transformers are added by default.
5. In the **Transformers in Use** section, next to the **Total Rows** transformer, click **Edit**.
6. If you don’t want to upload the total rows from the file to the platform, select the **Remove Total Rows** checkbox. This option is selected by default because total rows usually cause the file process to fail.
7. Click **Done**.