Duplicate row fillter

KNIME Analytics Platform
1

I have a case, related to duplicate row data. the condition is that I have 1 transaction number for example 1013310000. where I have transaction ID:

  1. PO1112345111

  2. PO1112345111 r (" r "which means cancelation)

  3. PO1112345112 (new transaction).

how can I do data filler based on the condition on transaction ID number 3?

Since these transactions are not sequential, it is difficult for me to determine “first” or “last”, and this can happen more than once if there is a re-cancellation.

2

Welcome. This is a classical case for building workarounds into data aka creating new problems with shortcuts. Check you can seperate your cancelation data from the others so your data is unique to identify. As long as you do not get clearance, you have to build the next workarounds to seperate the data in a way you want. Best case: make a definition per line “I am new”, “I am processed”, “I am canceled”.

3

Hello, greetings from me. Thank you for your attention and advice. The initial choice is to clean or make new initials, right? Does this mean that filltering is not possible in other ways?

Sincerely,

Eno.

4

Hi,

how about using a row splitter followed by a join?
Assuming that " r" is the sign for beeing canceled you can split the table into rows with and w/o this entry.

2 Likes
5

Like ActionAndi already said: The quick & dirty solution is a row splitter, e.g. based on a wildcard pattern "* r*. In this case, you have the cancelated ones seperated from the rest.
You do not see, if there is only one or two lines in this case! If you need this either, you have to split the cell first so you have to columns: ID and “r”-Field (empty, if not applicable). The you can go on e.g. with GroupBy followed by a Row Splitter.
Make yourself sure about the process and the goals you want to archive first. Your problem is not stated completely clear yet in which case a technical solution like KNIME cannot solve it 100%.

6

Hello, greetings from me. Thank you for your attention, advice and recommendations. I haven’t tried combining row splitter and joiner nodes yet. I will try this, hopefully my case can be resolved properly. Thank you.

Sincerely.

Eno

7

Thank you very much sir @ActionAndi , my case has been well resolved. Of course also to Mr. @McReady , thank you for your advice and attention.
Sincerely.

Eno

1 Like
8

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.