community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Read in Multiple Excel Files, with Multiple Tabs that have Different Schemas

Need your support on the below scenario - 

 

I've many files under my directory (as month wise) with date as suffix and I would like to read the latest date files for my alteryx workflow.

 

Example -  Directory Path (C:\Source Files) and file names as below -

C:\Source Files\SalesData_25-Jan-2018 

C:\Source Files\SalesData_30-Feb-2018

C:\Source Files\SalesData_10-Mar-2018

C:\Source Files\CustData_25-Jan-2018 

C:\Source Files\CustData_28-Feb-2018

C:\Source Files\CustData_01-Mar-2018

C:\Source Files\EmpData_25-Jan-2018 

C:\Source Files\EmpData_27-Feb-2018

C:\Source Files\EmpData_03-Mar-2018

 

I need to read from the directory (C:\Source Files)  for the latest files as input data source to the alteryx workflow.

 

SalesData_10-Mar-2018

CustData_01-Mar-2018

EmpData_03-Mar-2018

 

Thanks in advance. 

Alteryx Certified Partner

Hey @viswamtulasi,

 

You can use the Directory tool to read in the filenames, then parse out the date and use these to identify the latest files.

 

Depending on your needs you might alternatively want to write the names of processed files as a YXDB and join these to the directory filenames to identify the delta, which will be new files.

 

Thanks,

 

Jamie

Alteryx Certified Partner

Hey @viswamtulasi

 

Here's a mock up of a way to achieve this:

 

LatestFile.PNG

Highlighted

Thanks Neil for the mock up, when I tried to use the below solution with Directory I'm getting only one file...  and also how to take resulted files as input to the WF for further steps.

 

Appreciate your suggestions.

 

 

Labels