row comparison

[bruno29a]

So @Abhiram … is it resolved?

[Abhiram]

Hi @bruno29a ,

As of now i am following your approach, it is working.

As i am new to data analyst,
Can you help me that which things could need to be learn so that i can be strong in Data analyst. like i need to learn more on python as well as other tools(Knime etc) so can you suggest any ideas?

[bruno29a]

Hi @Abhiram , you can mark it as resolved by marking a post as solution. That way other users can easily find the solution, and the thread can be closed.

Regarding ways how you can learn Knime, what @iCFO suggested in your other thread is more or less what I would suggest too. @iCFO really did a good job there by giving different ways to do this

Any suggestions that to be strong in KNIME

Heavy participation in this forum is an amazing resource in itself. I am a recent KNIME adapter, but came into the platform with a solid Alteryx skillset. I have found that actively helping others is a great way to quickly develop my own skills as well. I also learn a ton by reviewing other approaches to solve the same problems. The Just KNIME it challenges are a good resource as well. Try and build things to be as dynamically adaptable as possible to allow easier incorporating of past process…

At least you are coming from Alteryx. I’ve not used any of these tools before. I’ve used Knime for about 1.5 years so far, and been active on the forum for just over a year (exactly 13 months). But Knime allowed me to do things that I have been doing manually for years, so I got very interested in it, and consequently, I used it heavily when I found out about it. In 2-3 weeks of using it, I learned about 90% of what I currently know. Like anything else in life, “practice makes perfect”.

[Thyme]

@Abhiram Please select Brunos post as solution if you’re using his Python script.

Speaking of solutions, here’s another one, using Recursive Loops:
It uses the same “kernel” for finding matching rows, with a minor modification. It uses fewer nodes and I can see it being faster than both the H2 version and the Python script, but for maintenance reasons, the Python solution is the one to go with.

How it works:

1. split off first row (+turn it into Flow Variables to compare against other rows)
2. find matches
   if there’s a match:
   a) first matching row scoots over to first row
   b) both rows status is set to “Yes”
3. first row (and its match) are collected in the Loop End
4. remaining rows go to step 1

row_comparison.knwf (282.4 KB)

[Abhiram]

Thanks @Thyme for another solution or process