Completeness Checking on the Data Input

Question

Hi Community,

I would like to ask if there is any way for us to check whether all the data or number of row /column in multiple files had been imported successfully in the Alteryx.

It is because i running the macro with multiple of data and would like to know if there is anyway for us to check to ensure all the data had been imported successfully.

Many thanks for your help.

afv2688 · Answer

Hello @SH_94 ,

There is no right answer here, you would need just to check your data outside and compare it with the results you get inside. Or if the data needs to sum a specific number you could just check that too.

For example, count the amount of lines you have retrieved from a database within the alteryx process and outside of it.

Regards

BenMoss · Answer

Here is one example showcasing how you can check if the incoming input has the appropriate number of columns as what you expect...

https://www.theinformationlab.co.uk/2019/05/30/how-to-reject-inputs-in-alteryx/

Ben

SH_94 · Answer

Hi @AbhilashR ,

Thanks a lot for the information.

May i know how you all normally do the checking in the alteryx ? Could someone give some examples so that i have the ideas on how to develop the checking from my side?

Thank you.