I am building a APP for this business problem, I will be inputting xls files, all with various header row starts.
I built a workflow with the input using the xls then using the Sample Tool to remove the noise above, then I used the dynamic rename to read in the headers.
To make it easier for the user I would like to use the Numeric Interface tool to ask the question, where does the header start for the xls. In this case the header starts on Row 7.
So I would like to use the formula based approach #1-1 to update the sample tool.
However I am running into this error.
Solved! Go to Solution.
The error is because the data incoming from the numeric up down is a string, but you are trying to do subtraction.
You simply have to cast the value as a number using tonumber() around it. In your case it would be tonumber([#1])-1
thank you that makes total sense. I assumed since it was a Numeric tool it was a double.