Ultimate Input Error

[Hongli1216]

I'm new to use the ultimate input. I already chose the table, but why I still got the " No table chosen" error message showing below. Thanks for your help! 

[Luke_C]

Hi @Hongli1216 

You need to append the table to the file path for it to work. Take a look at this thread:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-tool/m-p/903997

[Hongli1216]

Hi Luck,

Thanks for your information! I cannot open the Workflow because I have the old version. I already chose the table and I didn't know why it said no table chose. Please advise! 

[Luke_C]

Hi @Hongli1216 

You chose the table in the template file. You need to specify the table in each file you're reading in.

As far as you version issue, open the workflow in notepad and change the version (6th or 7th line) to your version, save, and open in alteryx.

[Hongli1216]

Good morning Luck,

Appreciated your help! All of the table are same name and same place in the Excel files. I used wildcard successfully if I only had 3 files in the same folder. But actually I have more than 500 files and I failed for these many files. That's why I tried to use the ultimate input. All of the files are Excel 97-2003 .xsl. My Alteryx version of the Ultimate input cannot put the table, that's why I put the Dynamic  Input after the Ultimate input. But I don't know whether that's correct. All of the files are same type and all of the table are same name and in the same position in the Excel 97-2003 files. Thanks!

Holly

[Luke_C]

Hi @Hongli1216 

I'm not sure what you mean by ultimate input (directory tool maybe?). If so, the directory tool does not read excel tab names which is why you need to append them to the file path (refer to the post i linked).

Would be helpful if your screenshot showed the error message

[Hongli1216]

Hi Luck,

Thanks for your patience. Please see the below screenshot, I used the 1 which I couldn't select the table.  And then I used 2 to select the table but I got the error message highlighted. If you know how to fix it I'm wondering whether you can just write down your solution for me. The link you refereed I couldn't download or open in my PC.  Appreciated your help!

[Hongli1216]

Hi Luck,

I rebuilt the WF like below. Please advise! Thanks for your time and patience! 

1. Direction: I wrote like below highlighted and I didn't know whether that's correct. Please advise!

2. Formula for the table: 

3. Dynamic input: I already chose the range from A13 to K600, but when I run this WF, the range didn't show up. I want to start form row 13 and end in row 600.  Can you tell me what's wrong? 

4. Because the range in Dynamic Input didn't work, I had to put the filter. But it didn't work well because I only wanted to choose the Asset column has words. Thanks!

[Luke_C · Accepted solution]

Hi @Hongli1216, put the range into your formula. The action is 'change entire file path', so all of the settings in the template file for filepath are overwritten (including tab and range). 

[Hongli1216]

Hi Luck,

Thanks for your great help! Appreciated it!

Hollly