We will create an Anatella-Graph that reads a CSV file, filter some rows out of the CSV file and write back on the Hard Drive the “filtered” CSV file.
Add inside the Anatella-Graph, the following Actions:
•CSV file reader :
•CSV file writer:
•Global Run Flag:
You should obtain something like this:
If required, click on the icon in the main toolbar: We are now in “Connect mode”: We will connect the different Actions together. Let’s do a simple left-click on the output pin of the “CSV file reader Action”: A red line appears:
Now, click on the input pin of the “Row filter Action”:
We just created a new arrow that means: “The table that is coming from the CSV file will be injected into the Row filter Action.”
Let’s connect all the actions together. We obtain something like this:
You will find detailed explanations in the sections 5.2.1, 5.5.7 and 5.24.1 on how to configure the “CSV file reader Action”, the “Row filter Action” and the “CSV file writer Action”. See the next section to have more information about the last action used: the “Global Run Flag Action”.
When you click on the button inside the main toolbar of Anatella, you execute the Anatella-graph: The below example creates a new CSV file that only contains “filtered rows”. Here is a screenshot of an execution example: