I need your help for this situation please:
I have many columns and I have to compare values of each column( values of the same row), and if i find one Repeated value, the value of the new column created ( in the same row) will be “1”.
PS : I have to compare just if the value is not null.
Thanks for your help !!.
I will be grateful,
Best regards.
And sorry for my bad english :’(.
Table Row To Variable Loop Start node (loop over row)–> Transpose node (to have it in column format) --> Row Filter or Missing Value node (to remove missing values) --> GroupBy node (to count unique values in Column) & Extract Table Dimension (to get number of rows) --> Now compare those two values and if are same write 0 (?) and if are different write 1 (Rule engine node) --> Loop end (will append everything in one column with 0s and 1s)
You will probably need Column Filter/Appender node in loop to have only table 1x1 (with 0 or 1 in it) at the end.
I haven’t test it. Try it out and give me feedback. Good luck
In group by node in each loop iteration you need different Row. So first time it is Row0, then Row1, Row2…
You will get this by controlling aggregation column name with flow variable. When you use this loop there is automatically created flow variable currentColumnName with name of current column in loop. Use it.
In Rule engine node if you use TRUE => 1 you will add (or replace depending on node configuration) column with all 1s. This way you can use TRUE => “flow variable name” that holds number of rows.
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