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.
@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.
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. 🙂
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
@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'
I have selected table but it showing error
is it intented that you filter on false in your filter?
Currently Earlier problems has solved but only header is pulling . no other data is coming under the header..
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?