Input Latest File from a folder

I am trying ti get my latest csv file to be loaded to Alteryx for further process. I have created a process which return the name of the latest csv file but i am unable to read that file. I tried using Dynamic Input but not surer how to enter file name which I am getting from my workflow. Below is my process....... Looking for help

Input

Accepted answers

Kenda

@Mruhullah Is the 'Input Data Source Template' that you're using in the Dynamic Input tool also a .csv?

All comments

NickC

Hello,

Your workflow looks correct from a high level. What error message are you getting when you run the workflow?

Make sure that the Input Data Source Template is pointing to a .CSV file.

You don't need to enter the filename as it will be pulled in from the 'fullpath' filed you have selected

Thanks,

Nick

Kenda

Hey @Mruhullah. I followed the process you laid out in the photos from your post, but it seems as though it should be working. Did you use one of the files from the folder that you put in your Directory tool as the Template file? Could you explain more what the problem is that you're having such as an error or just having no data coming through the Dynamic Input tool?

Mruhullah

Below is the error which i am getting. I have the CSV file named "report1507189259630.csv" in my download folder.

SFYODOR

Bumping this last question. Where/how do I enter the specific sheet in the dynamic input?

Riwen

On the Dynamic Input tool, click the Edit button, and then you'll be able to select the sheet you want to go forward.

SFYODOR

@Riwen This option was not working. However @IraWatt provided solution that worked by including the sheet name in filter tool.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280