I got an advice recently on looping through columns and maniputate them on the below question:
Unfortunately I couldn’t use it,as I want the scope of the involved fiels control via variables and here is where I am having problems.
I thought that included/excluded_name-variables are invented for this purpose, but using them the workflow gives result that I don’t understand. Include/exclude vars don’t do what I thought it will.
I upload a wf to demonstrate.
Thanks rule engine loop v3.knwf (27.6 KB)
Since it’s a follow-up question it’s fine to just continue in the original topic. Pro tip: try to be as precise and completely as possible in your questioning. That would have prevented me spending 30 minutes working on a solution that was never going to be of any help anyway
What I would do is add a Column Filter or Column Splitter in front of the loop and make that one variable controlled with the string array from the second flow. This depends off course on if you want to retain the columns that you have not used for the rule engine evaluation. You can merge them with a Concatenate node. Otherwise the flow variable controlled Column Filter is sufficient.
What I don’t understand, why appear all of the columns in the collected result with “Iteration” mark, and why they don’t on the workflow you created upon my question.
That’s probably due to the difference between the Loop End (Column Append) and the Loop End nodes. They are closely related but offer different options. The latter contains an option to add the iteration mark which I assume you are seeing.
