This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!
Morning everyone, regarding the formula tool, i do have a couple of questions. Are multiple columns able to be updated with a single expression? And can the expression remove already existing columns?
Answers to your questions.
1. Are multiple columns able to be updated with a single expression?
No, you would need mutiple expressions to update mutiple columns. If the expression is same you can use Multi-Field formula tool to apply the formula on mutiple columns.
2. Can the expression remove already existing columns?
No, Formula tool doesnt have the capability to remove columns you would need a select tool or tool with embedded select window (like join tool, append tool) to remove columns.
Hope this helps : )
As atcodedog05 said, use the Multi-Field formula tool to update multiple columns.