Is there a way Alteryx can consume input files by dynamically passing in a value.

[SrinivasanSugumaran]

Hi Team,

I have a folder where in there are files of the same format but with different date.(sample attached below). Is there a way i can key in the number of days as a parameter by the user so that alteryx consumes only those number of files.

Input File 2022_01_01.xlsx

Input File 2022_01_02.xlsx

Input File 2022_01_03.xlsx

Say for eg. i create a col. Total days, and if i dynamically update the value as 2 for Total days then my workflow should consume only the first 2 files.

Appreciate your help.

[Qiu · Accepted solution]

@SrinivasanSugumaran 
Given the shema of your input files are same, we can do something as below.

[grazitti_sapna · Accepted solution]

Hello @SrinivasanSugumaran, there is no direct way to your requirement as of I know but I hope this helps.

In the below scenario you will not have to read all the data then filter out the records instead read the files first then filter the required file then read the data.

1. I used a directory tool to read all files in the folder, as you mentioned it will have the same schema. Then I used the record id tool to assign an ID assuming the file names are sorted as in the screenshot below.

Using the text box tool I am dynamically passing the value 2 which will store the value in a field "Value" used in the formula tool.

Using the filter tool I filtered the value assuming the minimum value of the days would be 1. Below is the logic.

Therefore when running the workflow as an app you will get the following values. (Total Days=2)

2. Next step would be using a dynamic input tool using the following configuration.

Getting the final result.

I hope this really helps!

Thanks!

[SrinivasanSugumaran]

Thanks @Qiu  and @grazitti_sapna . It worked.

[Qiu]

@SrinivasanSugumaran 
Glad to help and thank you for the feedback.

[suby]

Hi Sapna,

I did replicated your workflow Macro but bit stuck with how to run that as an app..

When i downloaded the yxwz i cant see the workflow any suggestions ?

[DavidSkaife]

Hi @suby 

If you right click on the file and select edit that should open it in Alteryx as the workflow, rather than as the app itself

[suby]

I did tried to right click the yxwz and selected edit using the Alteryx designer but still i get the app Interface..

[grazitti_sapna]

Hi @suby, try opening the file from Alteryx. Please look at the screenshot attached.

Another way would be to drag and drop the file into alteryx canvas.

I hope this helps!

Thanks!

[suby]

Hi Sapna,

Thanks that works just couple of questions.

- Once this Macro is done what's the next steps to test the app.. I presume this Macro will give the user the ability to type total Days say for example if the user types in 2 then it should pick the first two files is that Right ?

- Once the user types in 2 then it should pick the two files and then how we can see the combine Data from those two files..

Thanks