Hello, How do I get output using formula tool with the value 'My name is Anisha'
GetWord([Field], 2). Trying this formula but getting error as "The field "" is missing. Compare the tool configuration with the input stream"
Any suggestionhow do I get output using formula tool or any other tool?
Hi @AltAnisha ,
this error is coming because formula tool is not connected to any input tool and there is no column named [Field].
use text input tool to write your input then use formula tool.
please see attached workflow.i hope it will be helpful for you.
Two reasons that it might be happening are:
1. Your input to the formula does not have a column name. Check if your formula tool is referring to a column or creating one.
2. Your meta data is not passing down the tools. This shows error but disappears while running.