I have a task that is easily solved through Excel, but I can’t figure out how to do it through Knime.
Here is the list of orders. As we can see, there are duplicates that should remain. I made the Countif column for clarity using the COUNTIF(A:A;A2) formula. This column is not needed. We need the Result column, which is calculated by the formula IF(COUNTIF($A$1:A2;A2)>1;0;1).
In fact, the task turns into a line-by-line expansion of the range of orders with a count of their number for the current sample, assigning the first value to 1 and the remaining 0 if they are repeated.
Hi @badorak & welcome to the KNIME forum community
This can be easily implemented using a -Lag Column- node on the “Order” Column.
Could you please post your data as a “copy and paste” on the post or as a text file ? It will help us to directly reply to your question with a solution based on your data. It saves us the time to enter the data by hand
A perfectly simple and elegant solution. Tested on a large array - it works fine.
I also wanted to ask why there is an “Interactive Table(local)” node at the end?
The -Interactive Table (local)- node is a very simple though useful node too. At a first glance, it looks like just a node for visualizing tables, the same as the output view of any node. However, it has the advantage of also allowing to hold on top the table view, which is not always available on the manipulation nodes:
Once the option “Always on top” is checked, one can continue to work on the workflow or run it whilst the table remains on top. This makes easier the visualization of results on the fly while the workflow is running or when one uses the hiliting options of nodes.