Now i want to filter the column “Customer” with “ABC GmbH”. Then i want to make some manipulations and calculations with the rule engine etc. After that i want so safe this table as a CSV file (Name: ABC GmbH). Then i want to make the same step for “DEF GmbH” respectively with all values from the column “Customer”. The result should be that i have for all values from the Column Customer one CSV file.
Do you have any idea how i can do that?
It would be perfect if you can upload a sample workflow for me.
sounds like a job for a group loop (group loop start node).
You select column “Customer” as your group column and then build your logic.
When it comes to saving it as a .csv, inside your loop you will have access to a flow variable “Customer”. You can use that to construct a path to the location where you want to save the .csv and then pass it to .csv reader to drive location and file name.
Maybe share the current state of your workflow or ideally example data then I am sure someone can prototype something for you.