Input files extraction from folder

Question

Hi Team,

I need to import the files from one folder but the challenge here is the folder name continuously changing day by day.

folder name = todys date.

so how can i import the files from the folder by not changing the file path every time - please guide me on this, thanks.

Watermark · Answer

Does the file name change also, or only the folder? Does the prior folder still exist or is it completely deleted/archived?

TheOC · Answer

hi @Jaganmohan

A dynamic input will allow you to specify a path in your data, and read data from the file found at that path.
https://help.alteryx.com/20214/designer/dynamic-input-tool

You can build this path using a formula tool, and the datetimefunctions (datetimetoday() ), to create the path to your daily file.
You could also use a directory tool to scan the whole folder that these folders reside, and pick up the file that has last been created. This would again require a dynamic input tool.

Hope this helps,
TheOC