> ## Documentation Index
> Fetch the complete documentation index at: https://docs.gocrisp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Selecting data sources for destination connectors

When setting up destination connectors, you can select and customize the data that feeds from Crisp into other applications.

**Note** : Before you begin, you must add a destination connector. Instructions for adding a destination connector differ depending on the application to which you want to export your data. For instructions, see [Exporting your data](/docs/support/articles-About-Crisp) and select the article for the relevant destination.

**To specify what's included in your destination data feed:**

1. Log into your [Crisp](https://platform.gocrisp.com/) account.

2. Add a destination connector by following the instructions in the relevant [Exporting your data](/docs/support/articles-About-Crisp) article.

3. From the *Connector source data* section, select the **Select** button\
   <img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Select_Connector_Source_Data.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=219e07b85038b0cc708d01a58551e03a" alt="Select_Connector_Source_Data.png" width="542" height="168" data-path="docs/support/images/Select_Connector_Source_Data.png" />\
   The *Select source data* screen appears with a list of your available source connectors.

4. From the left side bar, select the source connector from which you want to export data\
   (e.g., *UNFI* ).\
   <img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Selecting_Outbound_Data_Sources.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=bceccd781a319bbc97fe2e55d708915e" alt="Selecting_Outbound_Data_Sources.png" width="574" height="882" data-path="docs/support/images/Selecting_Outbound_Data_Sources.png" />\
   All the tables and columns for the connecter you selected appear.

5. Select a table (e.g., *Product by Brand with Expiration* ) that you want to include in the destination data feed.\
   **Hint:** You can select the book icon to the right of a table name to see its documentation.\
   <img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Selecting_Outbound_Data_Sources_002.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=874615d34f1893bfb5f1aff0b797ea48" alt="Selecting_Outbound_Data_Sources_002.png" width="1954" height="714" data-path="docs/support/images/Selecting_Outbound_Data_Sources_002.png" />\
   The available columns for the table appear at right.

6. Select the columns you want to include. Columns are divided into the following three types:

* **Time Key** : Controls how the report columns are rolled up by time.
* **Dimension** : The grouped columns in a table. For example, if a table lists every car sold in the United States, and you want to display the number of cars sold per manufacturer, the dimension you want to choose is *car manufacturer* (the resulting data is then grouped by manufacturer).
* **Measure** : Fields with values that can be measured or used for mathematical purposes. Crisp currently only supports sum calculations for measures.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Selecting_Outbound_Data_Sources_003.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=e82799664873a452178dc31e3114bf99" alt="Selecting_Outbound_Data_Sources_003.png" width="824" height="616" data-path="docs/support/images/Selecting_Outbound_Data_Sources_003.png" />\*\*\
Hint\*\* : You can click the **Select all** and **Select none** buttons to include or exclude all items in the tables and columns.

7. You can change the time frame for how your data is rolled up, if, for example, the selected connector provides daily data, but you want to work with weekly data in your exported data feed. Just select a time frame column (e.g., *report\_date* ), then select a time transformation (e.g., *Weekly* ).

**Hint** : When you select a time transformation or deselect a column from a table, Crisp performs some operations to condense your data. For all selected Dimension columns, Crisp will group rows that have the same values into a single row. For all selected Measure columns, Crisp will aggregate values using a sum operation. The **Group By** and **Sum** labels help you see which operations apply to each column.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Selecting_Outbound_Data_Sources_004.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=e6573235bb02650841f434af6d92b4d8" alt="Selecting_Outbound_Data_Sources_004.png" width="474" height="890" data-path="docs/support/images/Selecting_Outbound_Data_Sources_004.png" />

The time transformation is applied. Selecting a time transformation will not change any of the sums. Your table will instead sum your data at the granularity you selected.\
**Note** : For the Whole Foods connector, if you select a time transformation, you must deselect the ***week\_ending* **and \_**weeks\_ago** \_columns or your time transformation will not take effect, as these columns force a weekly aggregation.
8\. If you want, review your selections before accepting them in the *Selection* panel on the far right of the screen. You can click on the condensed dimensions and measures to expand the full list of included items.\\

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Selecting_Outbound_Data_Sources_004.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=e6573235bb02650841f434af6d92b4d8" alt="Selecting_Outbound_Data_Sources_004.png" width="474" height="890" data-path="docs/support/images/Selecting_Outbound_Data_Sources_004.png" />

9\. To finalize your selections, select the **Accept** button.\\

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Excel_Outbound_004.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=c96f3653ba70136d3b946246a9eee881" alt="Excel_Outbound_004.png" width="680" height="1066" data-path="docs/support/images/Excel_Outbound_004.png" />

The window closes and you return to the connector setup screen.

10. If you removed data from an existing connector, an option appears to clone your connector. You can select this option if you want to create a copy of the connector with your changes, so you can avoid disruptions to downstream reports and processes that use the original connector.\\
    <img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/selecting_outbound_001.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=1a548c347b1d18ee157be54819f4f0f9" alt="selecting_outbound_001.png" width="820" height="198" data-path="docs/support/images/selecting_outbound_001.png" />
11. Once you finish setting up your connector, select the **Save** button.

<img src="https://mintcdn.com/crispinc/hAIFVRhvGJHJU0Hr/docs/support/images/Connecting_Retailer_Portals_005.png?fit=max&auto=format&n=hAIFVRhvGJHJU0Hr&q=85&s=55425a14637efb4f42dd70ad14cf7e06" alt="Connecting_Retailer_Portals_005.png" width="298" height="114" data-path="docs/support/images/Connecting_Retailer_Portals_005.png" />

A diagnostic checklist appears on the right side of the screen. Once all the items are complete, green check marks appear next to them and the connection is finalized.
