Want Input data from Specific Directory through Directory tool

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,

Test.yxmd

Workflow

Accepted answers

binu_acs

@Srawat One way of doing this is by specifying the sheet name in the formula tool

Test (2).yxmd

All comments

ShankerV

@Srawat

I see as per your question, you need to read Alteryx Reconciliation/Testing.

However the Directory tool is mapped to the below highlighted location.

Many thanks

Shanker V

Srawat

I have updated the directory but still getting error. Thanks

Test.yxmd

ShankerV

Hi @Srawat

As per the input screenshot I see Testing\SohanRAM

But as per the Dynamic input, I see other link and completely different filename too. Please correct.

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

Srawat

Hi, I am unable to understand how it is resolved. please refer below location. I have updated the same location. but still same error.

binu_acs

@Srawat One way of doing this is by specifying the sheet name in the formula tool

Test (2).yxmd

Srawat

Perfect solution Thank you so much.

Srawat

@binu_acs Hi, I want to make more automatic, In the below screen file "RAMsohan" appearing in test folder. If the file name changes with "RAMsohan123" will it pick the data from the file.? I want like this type of WF. First name "RAMsohan" will remain same last can be changed. however pick the data. Can you please help me in this way.

Thanks.

binu_acs

@Srawat The Dynamic input tool looking for a template file, you can use a copy of your original file here, it is not necessary that you need to use the exact file in the dynamic input put tool, you can use any file but make sure that the columns are same as of your input file.

Srawat

@binu_acs I need more help on the query. I have prepared a workflow and used interface tool as well. In the dynamic tool I am getting error that pls make sure path is correct. In the folder there is file name "Deferred Income CKInc 05-31-22" and if I change the file name with "Deferred Income CKInc 09-34-21" then it's showing error. 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.

Thanks,

CK Revenue WS - WF.yxwz

binu_acs

@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.

binu_acs

@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 -

binu_acs

@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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703