Error message based on data

Hi all,

I have an requirement.

Please help me out.

Consider the following sample data,

Roll number	Maths	Science	English	Hindi	Marathi
1	45	45	45	45	45
2	45	45	45	45	45
3	45	45	45	45	45
4	45	45	45	45	45

Condition: -

I want to check if a particular column is missing from the input file.

If it is missing then it should give an error message on the (ANALYTIC APP) interface app that "a particular column name is missing".

For eg.

if maths is missing then "Maths column is missing in input file" and so on it will check for each column and if all the columns are available then it should execute the analytics app.

I have searched for error message tool under interface category but it is only working with interface tools.

So any solution of how i can get the error message based on condition in an pop window in analytic app.

Datasets

Accepted answers

pedrodrfaria

Hi @vijaylnyadav

This below was a solution I saw a long time ago with a similar use case.

Here is the Link: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Tell-User-If-Expected-Columns-Are-Undetected/td-p/328702

The workflow is attached below. You would need to populate in the workflow the expected columns, then it would let you know if they were missing. You can create a logic to customize the message to what you are looking for.