Source File missing notification from Alteryx

[Karthick461]

Hi,

 I am taking more than 300 files into Alteryx from common share folder. Name of the folders are like below

File_india_1

File_india_2

File_india_3..(even more)

File_America_1

File_China_1

File_china_2..(even more)

File_Japan_1,... like wise more files for all locations.

I have predefined 5 locations ( India, America, China, Japan, Mexico ).

How to notify from Alteryx that all locations files are there in the folder or any location files are missing.

[atcodedog05]

Hi @Karthick461 

Here is how you can do it.

Configure input tool to get filename like below

Workflow:

Hope this helps : )

[csmith11]

Custom messages can be creating using the message tool.

I'll share an example workflow that may give you some different ideas of how to leverage this tool for your use cases.

[gabrielvilella]

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?

[atcodedog05]

Hi @Karthick461 

The answer to both your question is Yes. Other columns will come as regularly and count record is an Alteryx pre-existing tool and will be available for all users.

Hope this helps : )

[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

[csmith11]

Just a slight modification, I was able to check if at least 1 value was found in a group, If a group is not found, then that group comes through the R output anchor causing a warning.

[Karthick461]

Is there anyway we can get this info as Email notification ?

[atcodedog05 · Accepted solution]

Hi @Karthick461 

It's possible in my method you just need to use reporting and email tool after it.

Workflow:

Hope this helps : )