Data validation on Input Excel file

aakashraj

Hi,

I am new to Alteryx and I am trying to build a flow which will perform validation on input excel file. 

1) When there is any column that doesn't have any value, it should give an error message. 

2) When there are more than 1 row in one of the input file, I should receive an error message.

Please suggest how this can be achieved.

Thanks

messi007

@aakashraj,

1- My input looks like below

2- I count the null values for each column

3- Transpose to have values for each column

4- Count the total rows in the data set in order to compare

I added annotation to each to tool to help you 

Attached the workflow,

Hope this Helps,

If this solve your need please mark it as solved. It will help others.

Regards,

Errors_20210317.yxmd