Oftentimes, all of your data will be in one file and will need to be split out in order to build comparisons. Once you've uploaded your master data file into the platform, you can create subsets of your data (splits) one at a time or in bulk via the data library.

In this article:

The importance of metadata

While the text component of a data set will always be the central object of analysis in Relative Insight, associated metadata points (e.g. demographic details of survey respondents) can be used to split out a master data file. This will allow you to build multiple comparisons using the same data, to get a 360° view of your audience.

In the example below, we can build at least four unique comparisons using this single data set. In each case, the text being analyzed is the same, but it is grouped differently, based on one of the following:

  • Gender

  • Age

  • Location

Creating splits in bulk

E.g. creating a unique data set for each country from which you've received survey responses.

Bulk splitting can be used to create a maximum of 20 data sets at once.

  1. Within the relevant project folder in the data library, select the checkbox next to the dataset you want to split

  2. Select the advanced split icon from the bulk action menu at the top of your data list

  3. In the metadata column, select which pieces of metadata you want to use as the basis for creating your splits. For each metadata point selected, a unique data subset will be created that only includes text associated with that attribute. The subsets you're creating will be previewed in the right-hand pane.

  4. Ensure the setting at the top of the right-hand pane is set to 'Split all results', and if desired rename the new data sets before completing clicking 'Split' to finish

Combining metadata points into a single split

E.g. group together survey responses from different age groups to create wider generational segments, such as under 25 years of age

In some situations, you might want to group together several metadata points and their associated text.

To do this, follow the above approach selecting only the metadata points you want to group together. Once you've done this, change the setting at the top of the right-hand panel to 'Combine all' before clicking 'Split' to complete the action.

Multi-condition splits

E.g. creating a subset of your data only including survey responses from respondents, who are based in the US and are under 25 years of age.

This operation currently supports 'AND' logic only, meaning if you define multiple conditions only the pieces of text that meet all of them will be included in your new data set.

  1. Hover over the applicable data set and select ‘Split’

  2. Use the dropdown menu to define a rule for your split then click 'Add Rule'

  3. Add additional rules by clicking 'Add another'. A preview of the data set size will be presented in the bottom-right corner of the modal. When you're done, click 'Finish it'

  4. Give the new data set a name and click 'Create the split'

Did this answer your question?