So I have a specific task that I am wondering if a KNIME workflow can achieve.
The input to the workflow will have two columns
Col1 Col2 189526 BIJFCG 123456 NULL
There is Cypher that values in Col1 will need to follow in order to generate the corresponding value in Col2
So, the task is to look at Col2 for NULL, pick the corresponding value in Col1 and then use the cypher to generate a value that is similar to Col2 but will put in Col 3
So the output should be
Col1 Col2 Col3 189526 BIJFCG 123456 NULL BCDEFG