Additional to manipulating the data within Data sets themselves, Qualibrate offers the capability of importing and exporting data from Excel.
This can be done in three simple steps:
Exporting the Data set
Manipulating the data in excel
Importing the Data set back
Export Data set
Procedure for exporting Data set:
Select the target flow;
Go to the Data sets tab;
Duplicate the Default Data set or create new Data set (by clicking +Add Dataset button);
Click on Actions and select Export option.
Data set will be exported in XLS document.
Manipulating the data in excel
When data are exported to the XLS file you can modify the values and add loops (iterations).
Prefix | Represents | Example |
---|---|---|
$ | Function | Formula |
@ | Reference | Reference to another parameter within a flow |
# | Skip | Ability to skip step from the Data set |
No prefix | Text | Text may contain ${P_VARIABLE}$ or $200 as plain text. |
\ | Escape prefix | Allows you to use the prefix symbols as simple text: /@20 will be considered as plain text @20 and not the reference |
Import Data set
Procedure for exporting Data set:
Select the target flow;
Go to the Data sets tab;
Duplicate the Default Data set or create new Data set (by clicking +Add Dataset button);
Click on Actions and select Import option.
Data set will be imported back to the Qualibrate application.
Bulk Data sets Export/Import
You can export and import Data one by one, but Qualibrate allows you to export/import multiple Data sets in one go.
Procedure
Select the target flow;
Go to the Data sets tab;
Open up the dropdown menu by clicking on the arrow on the right side of the +Create Dat Set button;
Select Bulk Export option.
Data set will be exported in XLS document with multiple tabs, where every tub represents a different Data set.
Comments
0 comments
Please sign in to leave a comment.