join sets flag when match = true

[Heinz]

Dear all,

I have two tables:

Table A
with column A1, A2 and Flag

Table B
with column B1, B2

join = table A.A1 with table B.B1

if match = true then A1.merker should be set to 1.

Any idea how to realize?

Thx for help!

Best regards,

Heinz

[takbb]

Hi @Heinz ,

From what you describe, one way I can think of… I would use a joiner node to join A1 (left/upper table) to B1 (right/lowertable), but configure it to return no columns from table B.

I would set it to return the matches rows and left unmatched on separate ports. The upper port from the joiner I would send to a node to set the value of the marker to 1 (is that the “flag” column or a different column? Anyway Rule Engine could handle that with TRUE => 1) And then I’d use a Concatenate node to bring together the rows from that Rule Engine with the rows from the middle port of the joiner (which is the left unmatched rows).

I think that should do it.

Writing this on my phone whilst drinking a beer… So I hope it works, …

[Heinz]

Hi takbb,

thank you very much for your idea; hope you did enjoy your beer

BR,

Heinz