Using List Files Node to create a Variable for Updating a Column in a Join

Hi @ScottF and @TardisPilot,

This might be close - “Loop in KNIME on a list of unique values”

Merges two columns into one by choosing the cell that is non-missing.

Loop in loop with “table row to variable loop start”: problems accessing flow variables

It all looks promising.