Rule-based Row Splitter seperate "PY" and "P"

Hi together,

it might be a sipmle question but i dont know how to configure the node (if the node ist right ;-)).

I have the column “Month” with the values:
PY P1
PY P2
PY P3
PY P4
PY P5
PY P6
PY P7
PY P8
PY P9
PY P10
PY P11
PY P12
P1
P2
P3
P4
P5
P6
P7
P8
P9
P10
P11
P12
TGT
PLAN
FC
FC-1

I want to have tow outputs.

  1. output :
    TGT
    PLAN
    FC
    FC-1
  2. output : the rest

Can I use the Rule-based Row Splitter and if its correct, how do i cinfigure it?

THANKs in advance

Hi @AndreasMichl

The Rule Based Row Splitter is the way to go. Use something like this:

$column1$ = "PLAN"=> FALSE
$column1$ LIKE "P*" OR $column1$ LIKE "PY*" =>  TRUE

gr. Hans

5 Likes

@HansS thank you very much for the solution :slight_smile:

2 Likes

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