Load into a Data Project Task

Suite
Customer Experience Employee Experience Strategy & Research
Product
Qualtrics
What's on this page

About the Load into a Data Project Task

The Load into a data project task allows you to take data that’s been previously imported by a data extractor task, and save that data into a Qualtrics imported data project. You can use this task to add new data records and update existing ones.

Once you’ve loaded your data into an imported data project, you can analyze your data using Stats iQ or a dashboard.

Qtip: After the task completes, it may take up to 1 hour for the data to be available for use in other workflow tasks.
Qtip: For more information on using data loading and extracting tasks, see using Workflows tasks to build ETL workflows.
Qtip: For information on general limits that apply to ETL workflows, see Workflow Limits. For any task-specific limits, refer to the information on this page.

Setting Up a Load into a Data Project Task

Qtip: Before setting up your workflow, make sure you’ve already created your imported data project.
Create an ETL workflow.
Select Data source (ETL extractor). You must first set up a data extracting task before you can use the Load B2B Account Data into XM Directory task. See using Workflows tasks to build ETL workflows for more information.
adding an extractor task to the etl workflow
adding an extractor task to the etl workflow
Click Add a data destination.
adding a loader task to the workflow
adding a loader task to the workflow
Select the Load into a data project task.
choosing the load into a data project task
choosing the load into a data project task
Choose the source extract data task that contains your data.
Shows how to set up a load data into project task.
Shows how to set up a load data into project task.
Qtip: For file size limits on data extractor tasks, see ETL Workflow Limits.
Choose a project to save the data into, or create a new project from scratch.
Click Next.
Now you’ll map your Source fields to your Data project fields. The source field is how the field appears in your data extractor task, while the data project field is how the field appears in your imported data project. For detailed steps, see Mapping Source Fields to Data Project Fields.
image of mapper
image of mapper
Qtip: For information on how to format date fields, see Custom Date Formats.
Click Next when you’ve finished setting up your mapping.

If you’d like to visualize your imported data project in a dashboard, see importing data as a CX dashboard source.

Mapping Source Fields to Data Project Fields

The source is the data pulled from your data extractor task. The data project is the existing or new imported data project you’re uploading the data to.

Attention: The Unique ID must have a unique value for every record in your file. This field can’t be empty.
Qtip: When data is imported, entries will be deduplicated by the specified unique ID field when setting up your imported data project. See the linked support page for more information. If your imported data project doesn’t already have a Unique ID, you won’t be able to update existing records in your project, only upload new ones.

Mapping to an Existing Project

Mapper when the project is existing. Nothing can be edited except which field is matched to another field
Mapper when the project is existing. Nothing can be edited except which field is matched to another field
In this setup, you match existing columns in your data source to existing columns in the imported data project.
Check that the correct Unique ID field is checked for the imported data project. Match it to the Unique ID field in your source.
You can see each field’s type. You can’t edit field types.
Click Add Field to add more fields to your mapping.
Qtip: Sometimes field names will vary across sources, especially with metadata. For example, surveys have “Recorded Date,” which is similar to an imported data project’s “creation date.”

Qtip: Not every field will have an equivalent. For example, imported data projects have a “last updated date,” but surveys don’t have anything similar. You can delete a field if it doesn’t exist in both sources.

Option to delete a field appears when you click the 3 dots, then delete
Option to delete a field appears when you click the 3 dots, then delete

Mapping to a New Project

Mapping to a new project lets you change field types, column names, and the unique ID
Mapping to a new project lets you change field types, column names, and the unique ID
Because you’re creating a new imported data project, you get to name the columns whatever you want.
Select the Unique ID field.
Choose the field type for each field.
Click Add Field to add more fields to your mapping.

Once you complete this step for the first time, your project will be created immediately. That means that when you edit this task, you will be able to edit mappings, but you won’t be able to rename columns or choose different field types or assign a new Unique ID. To rename columns and change field types, you can find the project on the Projects page and edit it directly.

Qtip: Make sure to delete any fields you don’t want to appear in your new imported data project.

Uploading Field Mappings

For new or existing projects, you can choose to upload field mappings instead.

Click Download a sample mapping.
Data mapping window
Data mapping window
Look at the field names listed in the mapper. Use these exact names in your file. IF you’re unsure how to name a field, click the drop-down and find it in the list.
Row 1 of your file should contain the names of all of your source fields.
Spreadsheet
Spreadsheet
Row 2 should contain the names of all the imported data project fields.
Qtip: Make sure columns match the same fields together. Exclude columns of data you don’t want to include in the imported data project.
Click Choose file to upload your CSV.
Choose file button top of window
Choose file button top of window
You can make edits to your fields, such as changing mappings or adding more fields, before you save your changes.
.
.
Save your changes.
Qtip: You can click Remove file if you want to upload a new file.

Mapping Field Values

In addition to mapping fields to each other, you can also map individual values.

Example: You’re pulling data from a survey into another destination, like an imported data project. One of these fields is a satisfaction rating question. You’d like to rename the different satisfaction ratings like this:

  • 1 should become Very dissatisfied
  • 2 should become Dissatisfied
  • 3 should become Neither satisfied nor dissatisfied
  • 4 should become Satisfied
  • 5 should become Very satisfied
Qtip: While this example is for the Load into a Data Project task, this concept works for many different data loader tasks. Furthermore, the user interface and steps are also the same for many tasks, such as the Add Contacts and Transactions to XMD task, the Load to SDS task, and the Load Responses into Survey task.
On the Map data window, click the 3 dots next to the field you want to map field values for.
Map data window
Map data window
Select Map value.
You can map your values by doing one of the following:
  • Upload values: You can upload a spreadsheet of all the values you want to map. Click Download CSV Template. The left column (from) should be the original value in the source, and the right column (to) should be the final value you want to appear in the destination. Upload this file when you’re finished.
    Choose file and download CSV template buttons at the top of a new window that opens
    Choose file and download CSV template buttons at the top of a new window that opens
    Qtip: Make sure to save your changes in a UTF-8 encoded CSV.
  • Manually input values: Click Add Row to input each value. The left should be the original value in the source, and the right should be the final value you want to appear in the destination.
    Add row button underneath a list of recoded fields
    Add row button underneath a list of recoded fields
If you want to set a value for empty fields, select Map blank fields to a default value. Enter the value.
Saving values
Saving values
Click Done.
Save your task.

FAQs

Do I have access to all extensions available through the Workflows templates?

Is there a link to all Workflows events and tasks?

What are Workflows templates?

What are workflows? / Where are actions?

Was this helpful?

The feedback you submit here is used only to help improve this page.

That's great! Thank you for your feedback!

Thank you for your feedback!