---
title: Data Ingestion
slug: target-cja-hol/data-ingestion
docTags: 
createdAt: 2023-10-26T20:21:41.456Z
---

## Download sample CRM data in the  .csv file.

::File{src="https://api.archbee.com/api/presign/HIx8QUtQkkTZMJDKAHTjJ-UrS3iuC0iCQNONM00OF3j-20250207-213431.csv" label="hol_crm.csv"}

This data is a sample representation of the CRM fields you would ingest to feed your business cases.

## Ingesting .csv data in Adobe Experience Platform

1. Navigate to the **Workflows** section in the left panel
2. Click on the **Map CSV to XDM schema** card
3. Click **Launch** in the right panel

::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/image392.png" size="50" isUploading="false" showCaption="false"}

 4\.  Select the **Existing Dataset** option

 5\.  Search and select your dataset by name from the dropdown

 6\.  Enable **Partial Ingestion**. Set threshold to the default 5%

 7\.  Update the **Dataflow** to include your initials

 8\.  Enable all alerts

::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-12at10.24.04AM.png" size="50" isUploading="false" showCaption="false"}

 9\. Click **Next**

 10\.  **Upload the .CSV file downloaded from your local machine**. Drag & Drop or click Choose files to upload and click Next in the upper right

::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-13at10.47.07AM.png" size="50" isUploading="false" showCaption="false"}

### Mapping source columns to XDM schema fields

1. As you proceed into the field mapping step, a couple of things to note;

- This mapping step is a requirement to ingest delimited files ONLY. Parquet and JSON formatted files can be dragged and dropped into the appropriate dataset since they are key value pairs and do not need to be explicitly mapped.
- Adobe Experience Platform's AI has correctly mapped most of the source fields to the best matched XDM schema field.
- Fix the ones that are not mapped as desired.

::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-13at10.52.11AM.png" size="50" isUploading="false" showCaption="false"}

1. **Add a New Field** We want to do a custom mapping to one of our added field.
   1. Click the New field type (+) button and choose **Add new field**
   2. Select crmind from the source scema
   3. Map to crmid to crmid in the custom object we added in the Schema exercise
2. **Add a Calculated Field** We will add a new field in the field mapping workflow using [data prep functions](https://experienceleague.adobe.com/docs/experience-platform/data-prep/home.html?lang=en). Data engineers can use calculated fields to perform in-row calculations that can be assigned to XDM attributes.
   - Click the New field type button and choose **Add calculated field**
   - Paste in this code: `concat(loyaltyTier,"-",loyaltyPoints)`
   - Click the Preview button
   - Click Save
   - Map to the loyatyTierPoints field in the custom object we added in the Schema exercise
   - Click Finish in the upper right

### Validating the ingestion workflow

1. Navigate to **Datasets**
2. Search and select your newly created dataset

::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-16at12.05.46PM.png" size="50" isUploading="false" showCaption="false"}

- Notice a batch is created as a result of the ingestion workflow that was triggered

::Image[]{src="https://adbecdn.azureedge.net/labs/archbee/toyotaaephandsonlabs/ScreenShot2023-09-16at12.08.22PM.png" size="50" isUploading="false" showCaption="false"}

1. Once the status for the batch says **"Success"**, click on the **Preview Dataset** button on the top right of your screen. This allows for validation of source columns to XDM schemas with the corresponding values.