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.
Hello Alteryx Community. Back with yet. another. question! Is there a way to tell a user, when running an app, that columns expected in order for the workflow to go through are missing from the input data set? To add another step, what about telling the user that there are columns in the data set that were not expected? Thanks :0)
Firstly you will need to create a list of your desired field names. I have then joined this against a field into tool to understand what fields are mising before using an error message tool to pass these to the end user.
That is a great question. I believe you are asking about metadata being different from expected, and not blank rows. The following workflow can help get you started with turning those missing fields and unexpected fields into their own streams. As an example, I put message tools on the outputs to warn me once the workflow / analytic app is ran.
Create messages from metadata changes
When ran as an analytic app, these are how the messages appear:
I should mention that most tools will raise an error or warning (depending on how critical) when a needed column is missing, so the approach above is sometimes unnecessary.
For example, if a column is missing from what a predictive model is expecting, it will send an error anyway. If the column wasn't selected for the model when creating the workflow, however, it will continue without error.