Purpose
The Data Transformer allows the user to transform data into another format. For example, columns can be removed, reordered or renamed.
It is possible to export the data, the product properties and the question/attribute properties.
Options
There are three main options tabs. These are for the data sheet, product sheet, attribute sheet.
Data sheet options
The user can select if the results should be split on judge, attribute, product, session or not at all. NA columns can be removed, or the NA values can be replaced with any other value or text. Product information can be included. If any product related columns need to be removed, this can be done in the 'Product Sheet options'. The queries can be based on References (e.g. Q1, Q2, Q3) or based on the real name (the actual attribute name). This option will decide which format needs to be used in the following fields.
- Columns to be removed:
- The user can add the references or real names of the columns that need to be removed
- If you have enabled the option 'Include Product Information' and product related columns need to be removed, the user has to include this in the 'Product Sheet options'.
- Alternative Starting Order of Columns:
- When the user wants the results table to start with a specific order of columns, please indicate the references or real names separated by a comma. E.g. Product, Judge --> The results table will start with the columns Product and Judge, followed by the remaining columns.
- When ending with ,! only the columns before ,! will be shown in the results table. E.g. Product, Judge, Sweetness,! will result in a table with only the columns Product, Judge and Sweetness
- An asterisk (*) can be used to select specific attributes.
- Select attributes based on the question name starting with a specific text. Bitter* will select all attributes that start with bitter, e.g. Bitterness but also Bitterness Aftertaste.
- Select attributes based on the question name ending with a specific text. *Aftertaste will select all attributes that end with Aftertaste, e.g. Bitterness Aftertaste but also Sweetness Aftertaste.
- Select attributes that contain a specific text. *Liking* will select all attributes that contain the text Liking, e.g. Overall Liking Intensity
- Columns to be renamed: The user can rename columns. For example Product=Sample will rename the column Product to Sample.
Additional sheet options
The same applies to the Product Sheet options, the Question/Attribute Options, Session options & Project options.
Results
Data
A table containing the results of the project(s) or data set.
Products
Attributes
A table containing information relating to attributes within your project(s)
Assessors
Sessions
A table containing information relating to any sessions within your project(s)
Products
A table containing data relating to the projects within your dataset