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.
I have a strange issue that I'm hoping someone can help me out with.
I'm using a select into a multi-field formula, selecting two numeric columns, outputting with the new_ prefix and then using an iif expression, on the output of the multi-field formula I can see the two new columns are created, but once I drop another tool after the multi-field formula the new columns don't appear. I've tried both a browse and a select, with no results. I did the same thing with a regular formula tool and had no issues.
I'm just wondering if anyone can help me out.
Let me know if you require any further information.
I was getting "invalid number" in my columns after using the select tool because I had duplicate headers in the file. Once I filtered out the duplicate headers and the NULL values. I then converted the data types using the select tool and lead that into the multi-field formula and it worked correctly.