Summary
This block is used to create new artifacts from a csv file. This artifact will then be used in the following blocks.
Here is how it works:
-
First a cache of the file is created: The block reads the file and keeps in memory the columns and rows of your file.
-
It creates the parameters column1 to columnX with X the number or columns in the file
-
Then it will iterate on all the rows of your file
-
As soon as the "conditions" slot return true, it will create the artifacts with the values at the current ro
Implementation
-
Drag and drop the block from the palette
-
Link the "execute" action from the "executed" topic of the previous block
Example
Here is the content of a sample file, the first column contains the slotpaths of some points, the second column contains values that we will set on the matching point
Our strategy iterates on the control points of our station
Here in the conditions, we compare {column1} which corresponds to a slotPath to the slotPath of the origin.
If it matches, a slotpath and a value artifact are created with the values at the matching row.
Properties
-
CsvArtifacts: Artifacts created by this block.
-
CsvFile: Ord to the file from which you want to extract data.
-
Conditions: The condition needed to match a row in your file and create artifacts.
If the conditions are left empty, it considers that you are comparing an empty string to another empty string, which returns true. The block will thus always match the first row
Advanced Properties
-
CsvSeparator: The character used to separate values in your file
Actions
-
RefreshCache: This block creates a cache that will last for 30 minutes, if the content of your file changed of if you put a wrong separator, you will have to refresh the cache.
Behavior: DO & UNDO
An artifact will be created.