---
title: Ad-hoc Data Ingestion
slug: nrg-rtcdp-hands-on-lab/ad-hoc-data-ingestion
docTags: 
createdAt: 2026-05-07T16:50:28.180Z
---

You have been asked to load an ad-hoc file into the RTCDP for testing. In this exercise you will ingest a CRM file and will need to perform a simple concat transformation to join first and last name.

::File{src="https://api.archbee.com/api/presign/1Jp0iolWv35Z_mkI7oUiT/W_Vp9hFZ2NRwHpkPMBZyh-20260507-170629.csv" label="CRM.csv"}

Navigate to **Workflows** then select **Map CSV to XDM schema**. Once selected click **Launch**.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/rx-F0iIvS-07ozZ1OXCk2-20260507-165405.png)

Select **New dataset** and provide a unique name for the dataset name by calling it **CRM + \{Your Initials}**. Then select **CRM** from the schema field and toggle on **Enable partial ingestion**. Click **Next**.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/hAtE-7UE_Wcg8H5r_0q3k-20260507-165806.png)

Now add in the CRM file and click **Next**.

Click on **Add calculated field**.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/XVGF9LkPWIJwKb_tMSHFS-20260507-170124.png)

We are going to do a simple Concat where we add first and last name. 

```text
firstName + ' '+ lastName
```

Click on **Preview** then click on **Save**.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/XJ_1kDnCqKgEG1RtR84D8-20260507-170447.png)

Now we can map this calculated field to full name then click **Finish**.

![](https://api.archbee.com/api/optimize/1Jp0iolWv35Z_mkI7oUiT/L5CnWOJ5YclTy2Z12wKJl-20260507-170601.png)