Source File missing notification from Alteryx

Hi @Karthick461, you can have a workflow that reads in all file names and performs a check agains a reference table, then you'd know if there are any locations missing. You can use the Email tool to send this information. However, if you are looking for a way to trigger a workflow if a file is present or not, you might want to look in this custom tool: https://github.com/bobpeers/Alteryx_SDK_EventTrigger

Karthick461

Thanks @atcodedog05

Since I am performing other actions from all the files I am importing, If I change my Output Filename as Field to "FileName Only" , will I still get other columns as regularly? Right..

Also the count records macro you used.. is that applicable for all users?

Karthick461

Thanks @csmith11 for your reply. But problem is,we cannot have the axact [Expected Number of Files ] count. it will vary for each location for every month.

If atleast 1 file is there for one location in the folder means , it should consider that file persent

Karthick461

Thanks @atcodedog05 @csmith11 @gabrielvilella for all your help

atcodedog05

Happy to help : ) @Karthick461

Cheers and have a nice day!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703