Comparison between rows in a single column

Hi Knime community,

Please help me on the task in Knime

conditions**:1)Same ETID, Currency, Cash Location, Amount, **
---------------->Activity :SETT and REIN
---------------->Transaction Sub type is same for all activity(BUY/SELL)
**2)Same ETID, Currency, Cash Location, Amount, **
---------------->Activity :SETT and SETT with Is ContraFlag = Y
---------------->Transaction Sub type is same for all activity(BUY/SELL)
**3) Same ETID, Currency, Cash Location, Amount, **
---------------->Activity :PART and REIN
---------------->Transaction Sub type is same for all activity(BUY/SELL)
**4)Same ETID, Currency, Amount, **
*---------------->Activity :ACTV and CXLD
---------------->Transaction Sub type is same for all activity(BUY/SELL)
**5)Same ETID, Currency, Cash Location, Amount, **
---------------->Activity :PART and SETT with Is Contra Flag = Y
---------------->Transaction Sub type is same for all activity(BUY/SELL)
**6)Same ETID, Currency, Amount, **
*---------------->Activity :ACTV and CXCR
---------------->Transaction Sub type is same for all activity(BUY/SELL)

i need to use the above conditions for my task

hi @HansS can u help?

I’m a little confused by your conditions. Can you post a larger example of the end result you want to get to?

Hi @Snowy ,

conditions:1)a)Same ETID, Currency, Cash Location, Amount, **
b)Activity :SETT and REIN**
c)Transaction Sub type is same for all activity(BUY/SELL)**

             2)a)Same ETID, Currency, Cash Location, Amount, **
                b)Activity :SETT and SETT with Is ContraFlag = Y**
                c)Transaction Sub type is same for all activity(BUY/SELL)**

            3)a) Same ETID, Currency, Cash Location, Amount, **
               b)Activity :PART and REIN**
               c)Transaction Sub type is same for all activity(BUY/SELL)**

             4)a)Same ETID, Currency, Amount, **
               b)Activity :ACTV and CXLD*
               c)Trnsaction Sub type is same for all activity(BUY/SELL)**

           5) a)Same ETID, Currency, Cash Location, Amount, **
               b)Activity :PART and SETT with Is Contra Flag = Y**
               c)Transaction Sub type is same for all activity(BUY/SELL)**

           6)a)Same ETID, Currency, Amount, **
              b)Activity :ACTV and CXCR*
              c)Transaction Sub type is same for all activity(BUY/SELL)**

Hi @Abhiram , didn’t you already created a thread with this question? Is this not the same as row comparison ?

2 Likes

Duplicate thread, please see here: row comparison