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.
Solved! Go to Solution.
Hi @Karthick461
Here is how you can do it.
Configure input tool to get filename like below
Workflow:
Hope this helps : )
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
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?
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 : )
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
Is there anyway we can get this info as Email notification ?
Hi @Karthick461
It's possible in my method you just need to use reporting and email tool after it.
Workflow:
Hope this helps : )