I'm finding a peculiar behavior when executing some jobs.
Let's see if i can explain the process flow:
[Lookup Node] looks up records on table [table_1]. Records it doesn't find are passed to a [Table Loader Node]. That table loader node, then appends these new records to [table_1].
What ends up happening is that table_1 becomes wiped, except for these new records.
My question is, how can I reference table_1 in the same job twice. first to check it then to append new records?
Thanks!