Load Into a Data Set Task

Suite
Customer Experience
Product
Qualtrics
What's on this page
Qtip: The functionality described on this page is in preview and is not yet available to all users. Qualtrics may, in its sole discretion and without liability, change the timing of any product feature rollout, change the functionality for any in preview or in development product feature, or choose not to release a product feature or functionality for any reason or for no reason.

About the Load into a Data Set Task

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

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.
Qtip: For more information on using data loading and extracting tasks, see using Workflows tasks to build ETL workflows.

Common Uses for This Task

The Load into a Data Set task can be used for creating datasets that can be used in the Merge task. This allows you to merge your new dataset with existing datasets in Qualtrics.

Available Dataset Schemas

Customer Care: This schema allows you to load data from third-party sources into Qualtrics. The following fields are required for this schema:

  • OwnerId: The ID of the employee who owns the case.
  • ExternalSystemId: The ID from the external system.
  • Status: The status of the case, such as New, Closed, or Escalated.
  • CreatedDate: The date the case was created.
  • LastModifiedDate: The date the case was last updated.
Qtip: In addition to the required fields, custom fields can also be added.

Custom: This option allows you define your own data schema. You can either upload a file with your mappings by clicking Choose file, or add them manually using the Add Field button.

creating a custom schema by uploading a file or adding fields manually
creating a custom schema by uploading a file or adding fields manually

Creating a Load into a Data Set Task

To use this feature, you’ll first create a new scheduled workflow with a data extractor task. Then you’ll add the Load Into a Data Set task and configure it with your chosen schema. Finally, you’ll complete your workflow by mapping each field in your dataset.

Create an ETL workflow.
Select Data source (ETL extractor). In this step, you’ll extract data that you can load to another destination. See using Building 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 set task.
selecting a load into data set task from the task catalog
selecting a load into data set task from the task catalog
Enter a name for your dataset.
selecting dataset schema and a source for a new load into data set task
selecting dataset schema and a source for a new load into data set task
Select the dataset schema you want to use:
  • Customer Care: This schema allows you to load data from third-party sources into Qualtrics. See Available Dataset Schemas for the fields available in this schema.
  • Custom: This option allows you to define your own data schema. See Available Dataset Schemas for more information about creating your schema.
Select a source ​​from the tasks you’ve already configured in this action.
Example: If you previously set up an Extract data from SFTP files task, select the SFTP connection from the dropdown. If you previously set up an Extract data from Salesforce task, select the object you configured from the dropdown.
selecting a data source for the load into a data set task
selecting a data source for the load into a data set task
If you have required fields, use the Source fields menus to map fields from your data extracting task to your dataset.
mapping dataset fields
mapping dataset fields
Attention: The required fields for each source vary based on the dataset schema you selected in step 6. See Available Dataset Schemas for more.
Qtip: You can also map individual field values. See Mapping Field Values for more information. This support page is for another task, but the functionality is the same.
To add fields in addition to the required ones, click Add Field.
Qtip: If you want to delete an additional field you added, click the 3 dots, then select Delete row.
Click Select source field to choose the field in your source dataset.
mapping additional fields and adding custom attributes
mapping additional fields and adding custom attributes
Click Select destination field to choose the field in your outcome dataset. The default destination fields that appear when adding an additional field will vary based on the dataset schema you selected.
To add an attribute that is not listed by default, click Add a custom attribute.
Attention: This optional attribute will be added to this Qualtrics dataset, and you will be unable to modify or delete it without contacting support. The new field(s) will not be picked up by Qualtrics for 24 hours after the change is made.
If you are adding a custom attribute, type an attribute name in the text box.
adding a custom attribute within a load into data set task
adding a custom attribute within a load into data set task
Qtip: Only alphanumeric characters and underscores are accepted, and should not start with an underscore or a number.
If you are adding a custom attribute, click Select data type and select a data type for your field. For descriptions of available field types, see Field Types.
Attention: If you are using a date field, it must be formatted as a Unix Timestamp.
If you are adding a custom attribute, click Save.
Once all your values are mapped for each field, click Save.
Qtip: All required fields must have a source field mapped to them before you can click Save.
Make sure your workflow is toggled On.

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!