Can you explain your logic because here we compare numbers and I need to compare ( String) because all columns there type is String.
And what I should do in the first 'Rule Engine’Node ,
My idea is to compare number of unique values in row with total number of values in that row so it doesn’t matter if you have numeric or string values. If the number is same then all values in that row are unique so you will put 0. Else you put 1 because there is less unique values then the total number of values in row meaning you have one or more values repeated.
In this Rule engine node you add following rule:
TRUE => Number of Rows (double click from Flow Variable list)
How I can fix it, Sorry for annoying you !, but i’m new in tha manipulation of flow variables.
2- for the column expressions, I haven’t find it even I upgrate the version to knime 3.6.
No problem. You should go through some tutorials regarding Knime. That is good (mandatory) for start. Then creating workflows will be easier and more fun
Here is a one for flow variables. Flow variables are controlled on flow variables tab
After upgrading to knime 3.6, I wanted to add the extensions of “Knime Expressions” and I get this Error:
PS: I don’t have the probleme of Firwall.
How I can fix it Please! @ipazin wish one of Attribute that i have to add the CurrentColumnName variable in these parametrs:
And what is the goal of using the Column expressions and how to parameter it ?
Thank you very much for helping me, really I need your support !
Best Regards !
As you are doing manual aggregations then it is under aggregationColumn --> columnNames
Here 0 represents first column or in your case only column you have added on Manual Aggregation tab.
Regarding column expressions node it is used only to calculate difference and you do not have to use flow variables here. You just subtract two columns. But first install this node, read its description and you can use Knime NodePit (https://nodepit.com/category/) to find example workflows with it
:’(
And how the names of columns will changes for each iteration with loop ( Row0,Row1,Row3,…) even I’m not using in this node the flow variable ?!! @ipazin , Please help : (
Br.
Have I configurate the flow variable again in this Node ?!! How to do this please !
may you help be in this ? may be is the last question ! I don’t want to give up because it’s so urgent for me to resolve this !
This error means you have different column types in different iterations…
Go iteration by iteration and see what is result from first iteration and what from second one.
Don’t think so it is due to second Rule engine.
Ivan
Thank you very much for your help.and i’m very grateful for you !
In fact ,In the beginning I had 996233 rows , with transpose node the loop have to treat then 996233 column to get if there a repeated value. And that taked a lot of time (more than 2 days).
Is there any Solution for make that more fast, because I have to work a lot with this workflow ! and present the result in a report data.
Thank you again.
Bests Regards
I wish you a very good day !
Some of these operations do last a bit longer. Not sure there is a faster way but more then two days is a bit long! Can you share a workflow for me to check? How many column do you have?
For execution time you have Timer Info node which will give you execution for each node so you will see node execution time so you can optimize.