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

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.

Workflow

Accepted answers

Qiu

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

0607-SrinivasanSugumaran.yxwz

0607-SrinivasanSugumaran.zip

grazitti_sapna

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_workflow.yxwz

All comments

Qiu

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

0607-SrinivasanSugumaran.yxwz

0607-SrinivasanSugumaran.zip

grazitti_sapna

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.

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_workflow.yxwz

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 ?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703