---
schema_version: "1"
id: 98c5f007ef288f7e3ce989ae6435cfe5f38e481cb7ea4131ece20cc28770cb37
title: Preview Source Data in Marketing Cloud Intelligence
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_data_streams_tc_preview.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_data_streams_tc_preview.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bf763ce8a45049f1804957f6c69dc7e5807127506df1399c93a9252237e332df
description: After you upload your data with TotalConnect, a preview of your source data lets you see how Marketing Cloud Intelligence reads the raw data, including fields and their types. The table reflects all the fields (columns) from your source file. Each field is defined with a type—text, number, or date—and you change the type if needed. You can also change the date format.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Preview Source Data in Marketing Cloud Intelligence

After you upload your data with TotalConnect, a preview of your source data lets you see how Marketing Cloud Intelligence reads the raw data, including fields and their types. The table reflects all the fields (columns) from your source file. Each field is defined with a type—text, number, or date—and you change the type if needed. You can also change the date format.

## Field Types

Each field is defined with a different type (text, number, or date), and you can change the type if necessary. Click the column name and select the type.

![TotalConnect Datastream Preview](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_tcstream_preview.png)

## Date Type Fields

When it comes to date type fields, recognizing date formats is of utmost importance regarding data correctness and aggregation. In order to ingest a particular row of data, Marketing Cloud Intelligence must be able to read the date format correctly.

Since there are a variety of different date formats, Marketing Cloud Intelligence automatically recognizes the format that was used in the data source. In some cases, multiple formats are used, therefore more than one format is found.

To change the date format or add a second date format, click the Day column and then click the Settings icon. You can select a format from the list or enter a date format. To apply more than two date formats, use the `PARSEDATE()` function.

## Transformers

Transformers are applied to your source file to create the final data table that is used later when mapping. Four transformers are automatically applied: File, Table, Headers, and Totals. You can add transformers for more advanced file structure manipulations.

![TotalConnect Transformers n Preview](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_tc_transformers.png)

When you apply transformers, you can see how your source data is affected in Preview.

See [Transformers in Marketing Cloud Intelligence](https://help.salesforce.com/s/articleView?id=mktg.dato_data_streams_tc_transformers.htm&release=264.0.0&type=5 "Transformers are a set of configurations applied to files that are uploaded into Marketing Cloud Intelligence. Transformers are used to alter the structure of the data files in order to pull the exact data sets you need. They instruct the platform as to what data table must be extracted from your source file allowing you to manipulate the file structure.") for more information about what you can do with Transformers.

## Highlight Tool

Use the highlight tool to focus on a specific field type. For example, you can highlight all the date columns.

![Using the highlight tool to focus on a specified field type](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/data/data_tc_highlight_tool.png)

You can highlight date, text, and number fields, as well as columns added by transformers, which create additional columns, like transpose, or unnest.