In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Input files extraction from folder

Jaganmohan
8 - Asteroid

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.

2 REPLIES 2
TheOC
15 - Aurora
15 - Aurora

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

 

Cheers,
TheOC
Connect with me:
LinkedIn Bulien
Watermark
12 - Quasar
12 - Quasar

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

Labels
Top Solution Authors