Log status of access to the dataset (successful/unsuccessful)

[harrynguyen2000]

Hi all,

Is there any way to check if I have successfully access the dataset or not? Every time I collect data across the data sources, I want to it to explicitly say that my collection activity is successful or unsuccessful. Can the Test tool do the job? If so, then how? 

I'm looking for a simple solution, perhaps some formulas or another tool already in Alteryx Designer. Also, there is no need to log all access attempts in the past, so no I don't have to sort to complicated ideas like Mongo DB. 

Thank you in advance! 

[christine_assaad · Accepted solution]

Hi @harrynguyen2000 

If you want to configure Test tool to error out - if you get 0 records (i.e no data) - then you can configure it like attached.

You can also write message to the logs whether the process was successful or not.

You can also configure the Event so you get an email if there is an error (Test one you will configure).

Hope that points you to the right path. Cheers!