We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Multi-Field Formula Issue

7 - Meteor



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.




14 - Magnetar

I'm not able to replicate this locally :(

Have you tried pressing f5 to refresh the metadata inside the workflow?

7 - Meteor

Figured out the issue.


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.