Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic input

Mehedi
6 - Meteoroid

Only one source file will be replace every month in a folder location and the file name will be based on months name. How can I input that file in the design.Capture.PNG  

8 REPLIES 8
binuacs
21 - Polaris

@Mehedi Use the Filter tool and filter only the file name you want. If you provide the file name format we can help you do that.

Emmanuel_G
13 - Pulsar

@Mehedi 

 

By example ,If the files contain July, in the specification part of the file, you can indicate *july* to take them all into account. If it's August, *August* and so on such as the model below.

 

In your case, you have 3 letters so you can specify *Aug* by example to take all the files which contains Aug in their names.

 

Does this answer your request?

 

Let me know if it's not enough clear. 🙂

 

Emmanuel_G_0-1664379418359.png

 

Mehedi
6 - Meteoroid

 Basically I was looking only Month name portion to be dynamic. In my design we will delete the previous month file from the folder. In New file Only change in name of the file will be- month name portion.

i.e File name of July: "Total Interest Jul"

File Name of Aug: "Total Interest Aug"

 

So how can I make it dynamic only for month name. so logic will automatically pick the new file  

binuacs
21 - Polaris

@Mehedi I assume that when you run the workflow in the current month it should look for the previous month. The below filter formula will dynamically select only the latest month

 

[FileName] = 'Total Interest '+DateTimeFormat(DateTimeAdd(DateTimeToday(),-1,'month'),'%b')+'.xlsx'

 

binuacs_0-1664432086138.png

 

Mehedi
6 - Meteoroid

Mehedi_0-1664443006607.png

 

I have selected table but it showing error

Hamder83
11 - Bolide

is it intented that you filter on false in your filter?

Mehedi
6 - Meteoroid

Currently Earlier problems has solved but only header is pulling . no other data is coming under the header..

Mehedi_0-1664461614933.png

 

MattBSlalom
11 - Bolide

Silly question, but can you confirm the given file does actually have data in it?

 

Also, can you provide a screenshot of the Input Data Source Template configuration in the Dynamic Input?  For example, do you have a value in the Record Limit field?

Labels
Top Solution Authors