Dear Knime community,
I have an excel sheet with 100+ columns, named A,B,C etc.
I am trying to create a new excel file that would have the result of A-B, B-C, C-D, …
and therefore obtain this:
With three columns, it can be done manually. But I have more than a 100 of them, so it’s really not the best method. In the math loop, I can select the $$Current_Column$$, but cannot force the iteration to also selec the $$Current_Column$$ + 1 iteration.
The idea would be to write the following, in the yellow circle, but this returns an error.
Hope my issue is clear enough