Dear KNIME community,
I would like know how to solve the following problem:
We need to fill one of two cells of the output file based on the content of a column from the input file.
For simplification let’s assume the following:
File 1, Column A “Indicator”, Column B “Values”
File 2, Column C “Actual Values”, Column D “Forecast Values”
if Column A is “Actuals” then we need to insert the data from Column B “Values” in Column C of File 2.
Most likely we will need a loop that would look into each cell of File 1-Column B and fill either Column C or D in File 2.
Could anyone give us a hint on how to solve such problem?