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,

[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

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

[binuacs · Accepted solution]

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

[Srawat]

Perfect solution Thank you so much.

[Srawat]

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

[binuacs]

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

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