Want Input data from Specific Directory through Directory tool

[Srawat]

Hi,

I am trying to get input from the directory tool from a sub folder and then specific tab. However, getting error. please help me to resolve the error.

below is the testing folder and inside  i have test folder and inside that I have a file "RAMSohan" and in this file i have two tab so I want to get input from data tab. however, I am getting error. I have attached the WF pls help.

Thanks,

[binuacs]

@Srawat you don't need to change the path for the dynamic input tool every time, just make sure that the template file exists in the path, as I mentioned before it is just a reference template for the Dynamic Input tool, the actual path is deriving from the FullPath variable configured in the Field,

for your second question below, can you explain it a little bit more, please?

 Can we fix this issue In this folder the file numeric name will change every month, but I want that just Alteryx see alphabet name and pick the data. please advise.

[binuacs]

@Srawat One more suggestion, instead of multiple filter tool you can put all the filter conditions in one filter tool, will improve the workflow performance and readability

[Srawat]

When I filter the information from the interface app. like below as screen shot and finish. then I receive error refer second screen shot and also debug in third screen shot. please advise.

Error screen shot.

Debug -

[binuacs]

@Srawat I cannot run your workflow without the input files, for the dynamic input error can you please check if the file path is correct or if the excel files exist in the path?

Also for the first error please check data type of the below fields . make sure that the amount field is numeric and the [PC SAP] is string