Data Validation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I want to check it the data in a excel is populated or not and if it is populated then it is in correct format or not and based on the result generate a error report.
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@vijaylnyadav
Basically if there is warning during the execution of workflow, there should no major concerns.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please suggest some tools with the help of which i can check weather a specific cell in a excel consist of data and if data is not present then how should i generate an error message.
for eg. input data consist of employee id and employee name, so i want to check each and every field i.e data exists in a particular field and based on the validation i want to generate an error message.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vijaylnyadav ,
There is a tool called a "Test" tool that maybe can help to check if a field contains data. If it doesn't it will create an error message.
In the following example, I have nulled and emptied the Order ID and Customer ID fields. If you don't have any data in your excel file, that data should either contain null values or be totally blank.
Then I have added a test tool in my workflow, demanding that those two fields (Order ID and Customer ID) should not contain Null and Blank values respectively. Because they do, the workflow throws an error when it runs, with the following message appearing in the results pane
Hope that helps. About the format, I am not sure what kind of checks you want to do. If you can provide an example, that would be really helpful.
Regards,
Angelos
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You could something like
All data is ok and no blanks, so no error
Some data is blank, generate error message
Error message
So basically i am checking is any of the columns values are blank
If its blank then show an error message. Here is a resource on message tool configuration.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Message/ta-p/36308
You can also refer to the attached workflow
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I hadnt worked with Test Tool before.
Just took a look into @AngelosPachis's workflow on how its working. It seems like Test Tool is the upgraded version of Message Tool. Message Tool can handle only single validation and throw only single error message where as Test Tool can handle multiple validation and throw error messages accordingly.
This is Amazing 😎
Thank you for this knowledge share and great learning @AngelosPachis 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help 🙂 @vijaylnyadav
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂
