Tableau Input tool error "Specified Table does not exit"

[Fenrick]

Hello,

Currently I am trying to use the Tableau input tool(Tableau Input Tool | Alteryx Help) to pull data from my company's tableau server.  I have been able to enter my credentials and connect to the server, as evidenced by the fact that under "Connected to" it lists the proper Tableau server. Furthermore, I am presented with Data and Select Project options, as well as Select Data Source options. 

However, when I go to run the workflow ( which merely consists of the Tableau input tool and a browse tool), I am told that I need to provide a table name.  So I do, but then I get the message that "Specified table does not exist:<table name>. Context:0x7bd02a3b

I have googled this to no end and to no avail. Any help would be appreciated

[Genevieve]

Hi @lee75clark1 

I'd suggest a workaround. At the same time as you output to Tableau database, you could output to an Alteryx database and re-use that one as the basis of the records that were uploaded to Tableau.

In our team we have taken the habit of calling those "transit db". They serve as back up. 

And if you want to be absolutely sure the file to the Alteryx db is not written before the data were successfully uploaded on Tableau, I'd set the Alteryx db output in a control container which is only activated on the success of the Tableau update.

[JORGE4900]

To add to what @Genevieve is suggesting about outputting to an Alteryx database at time of publish; this is not a bad idea; I have been doing just that for many months; better yet; I dynamically save a snapshot of the published source with date and time because our Tableau Server does not keep track of data history; it only keeps track of Tableau workbook version history.

Just now I was trying to use the Tableau Input tool, and it is very buggy.

[pitmansm]

Same error. table1 no joy. what gives? Why not have it pull whatever is in there?

[Genevieve]

@pitmansm 

Maybe the table wasn't named table1 when the Tableau output tool was set up. it might be worth checking the workflow writing the data to tableau and check the output tab. By default it comes with table1, but the workflow creator may have used another name.

[pitmansm]

Tried that as well

Using DCM with fully selected Data source. 1.4.0 tool as that is compatible with our server.

Error: Tableau Input (2): Specified table does not exist: #1:table1.
Context: 0x7bd02a3b

[Genevieve]

There have been a couple new versions since yours. Have a look at the release notes Tableau (alteryx.com). 

[pitmansm]

Ok our sever version is 2023.1.1.361.

I See 1.4.0 is still there for 23.2 and older Server.

Are those Tab py3.8 1.4.1 1.4.2 supposed to be the same and work for our server? Why the name change?

[Genevieve]

Those numbers indicate a version of Python used in the code.

As to the server I don't know. We only have Alteryx Designer desktop here.   You may want to ask your Alteryx supplier if they have a support team.

[Drevlin]

Has anybody resolved this? Just installed the New Tableau add on. I can get the output to work but the Input keeps giving the no table exists error. The fact that I can select the table in the in the list and that I created the table using the export tool makes this error extremely frustrating. The table is obviously there. Is there some kind of additional data that needs to be added to the table name? Like the Schema?.

[JonathanAllenby]

Same issue over here. The Tableau Input and Output tools have been such a constant nightmare since their release.