Dear worthy friends,
I am using for each row to find a row with certain value and change something in the other column of the row. for that I am using for each row with the following scheme:
The goal is achieved, however something annoying is happened: after for each row is run and I write the datatable back to the same file, all the rows which were filled in with ‘#NA’ values are replaced by a number: -2146826246.
Can somebody explain why is this happened and how to prevent it?
*for some reason, I need to let the ‘#NA’ intact and not be changed if the row is not the one that needs to be modified.
For visual help, hereunder the excel after and before for each row (notice the change in the rows with ‘#NA’ value:
Before for each row activity:
After for each row activity:
Appreciate your guys input and happy holiday!