I want a transliterator (Google's) to be embedded in my site. I tried embedding it and I mostly succeeded. It is showing translations, but all of them for a word typed one letter at a time like it shows in Google input tools online like this:
I tried looking at the web console (Firefox), and understood that in the code that I have is sending a request whenever we hit a space. But Google input tools online is sending request to POST a request after every key press then getting and printing data only after space.
Not sure if it is a coincidence with upgrading from 2019 to 2021, but when I click on the input tools which bring in those heavy Excel files, it takes an awful lot of time for the configuration screen of the input tool to show up and equally long to make changes in the input tool for those files. Actually, I believe this drags down the overall performance of making changes on the workflow on any other tool, because Alteryx seems to go back and check every other tool the moment you make a change to any other specific tool. Sometimes, Alteryx overall is not responding for +30s after just clicking on those input tools....
Is there a way to prevent Alteryx from "refreshing"/reloading/reading input files at the step of the input tool configuration? Would it make a difference to override the system settings and to allocate more RAM? I have plenty of RAM (32GB); dedicating more to Alteryx shouldn't be a problem at all.
if i understand correctly, you're worried about configuring the input tool, and not the time it takes to actually read the file in? in that case, you can change the file path for the input tool in other ways than manually clicking it and changing the name in the configuration. one way would be an analytic app letting a user point to a file path. another would to put the file path in a Text Input tool or something in your data stream, then use a dynamic input and have it Change Entire File Path. then you are only updating a string in a Text Input tool the next month you have to run it.
I have an older workflow that was originally created in Alteryx 2018. The workflow has design choices which are redundant with Alteryx 2021; basically, I want to update the workflow and taking out unnecessary tools and complexity (i.e. the workflow uses select records and dynamic renaming instead of using the input tool's read from x row) but also to modify to new needs. The issue is that to do so, I need to make changes to input tools with heavy Excel sheets but also other modifications. Every time I click on the input tool with the heavy Excel sheets, Alteryx goes into application does not respond window message. I cannot efficiently modify the overall workflow when the workflow times out each time I touch the input tools; I suspect the input tools to be the issue because it takes a long time to load the input tool's configuration screen and "taking down" the whole workflow.
@Maskell_Rascal, unfortunately, all my workflows are centralized. Also, this workflow has multiple heavy Excel files on different network folders; due to this your approach will not work (saving the workflow in the same directory as the input file).
I am attempting to run multiple dynamic input tools as a work around for PL/SQLs limit of 1000 IN list values in a SQL statement. My output has around 9000 list values that I am trying to pass through my query(I created a record ID and filter 1000 rows at a time into the Dynamic Input Tools), however filtering and using multiple dynamic input tools seems to freeze my workflow.
I'm creating an app that will be running on Alteryx Server. The process starts with the user completing an input template (Excel file with multiple tabs). I have a File Browse tool set up to allow the user to select their input file. From there, it is connected to 6 different action/input tool pairs. Three pull in sheets and three pull in named ranges.
The action tools "Replace a specific string" - each one replaces the entire file path EXCEPT for the sheet or range name. In this example, the entire path other than the range "Contract_Summary" is updated with the user's file.
Running as an app from Designer (desktop), it worked as expected and I proceeded to build the rest of the workflow. Today, when I uploaded it to the Server to continue testing the app with other users, when I browse to my input template file, it then requires that I select a sheet or range. It never required that when not running on the server and the app doesn't work if any of the options provided are selected.
I've found a solution to this. Not ideal, since the user still needs to make a selection after browsing to the file, but they only need to do this once (rather than 6 times). The user will be directed to select List of Sheet Names.
A single action tool now updates a placeholder value in a text input. From there, a formula tool replaces "" with the sheet or range needed. This is connected to a dynamic input tool replacing the entire file path. Additional sheets/ranges can be retrieved by updating the replace formula. During initial testing running on the server, this solution worked in bringing in multiple sheets and ranges.
I am attempting to use the dynamic input tool to grab a single tab from each sheet and append them. I am using an Excel template with the same structure as the sharepoint sheets. The template is stored locally. The problem that I am running into is that the tool is attempting to append the file locations (sharepoint urls) onto the workflow directory, which is also local. I do not understand why this is happening, since I am using the 'Read a List of Data Sources' option to substitute in my url variable with the 'Change Entire File Path' option. In the attached image I have highlighted the sharepoint path (with some blacked out). As you can see it is being appended to the local path.
Test that you can download one of these files via the normal input tool by copy and pasting the link from the output of the Formula tool into an input tool. This will tell you whether the error is before your dynamic input or not.
The directory+dynamic input doesn't work for me, and the wildcard input doesn't solve the problem since I have an output for files with the same format and another one for files with different format (for this output, the columns are not named and I have my headers as rows in the output file).
Ok, I am not familiar with Google Input Tools - but my suggestion would be to first disable these and use instead the default input method provided by your operating system. MacOS and Windows both provide a Cantonese (Traditional) input method. if these works fine (as they do for me), then the issue is probably with the Google Input Tools and not with Coda.
for reference: I am using the standard pinyin keyboard on Mac Os and run coda in Chrome, and I have no issues.
I have been using google input tools (a Chrome extension) for my major input tool for my language. I used it for my designs before and was working fine. Recently, around 18/1/2023, what I typed started not being input into the text boxes in my design anymore.
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:. Context:0x7bd02a3b
I have googled this to no end and to no avail. Any help would be appreciated
Hello Caltang,
Thank you for your reply.
The reason I want to use the tableau tools to pull data from Tableau is because of company use cases whereby that approach would be the most efficient. I realize that I could query the database that Tableau is, however, that is not ideal in my situation.
Regarding screen shots I am attaching several, which have been cropped to remove sensitive information
The first error I get is when I try to leave the Anchor#1 table mapping area blank. I am told that a table name must be provided. "Please enter atleast one table"
Hello Oussaio,
I followed caltang's advice and submitted an Alteryx Support Ticket.
The issue is that the Tableau tools cannot pull in data that was created in tableau. For instance, if tableau queries snowflake, you will not be able to pull that query result data into Alteryx via the tableau input tool. If you try you will get the table does not exist error.
The solution is to query the data from say snowflake directly via the data input tool or In-database tools( I used the data input tool). then use the tableau output tool to push the workflow results to tableau. Now any data that you push to tableau via the tableau output tool will be retrievable via the tableau input tool.
to make this all work you must configure the tableau output tool as follows:
1) first make sure to set up DCM following this guide: How to: Set up DCM for Designer and Server (alteryx.com)
2) then create a connection to your database of choice, by entering and saving your connection credentials.
3) in the tableau output tool on the data tab click on the Select project option you want, then lower down the select data source you want. the first time you do this select "New Data Source". this is where your data will be pushed to
4) in the Options tab Name your data in the Data Source name field, then Select the Output Option as create the first time you publish the data, and change it to Overwrite for updates to that data in Tableau. Make sure to leave Data Source Metainfo blank, and don't select Encrypt at Rest or local path. In table Mapping in the table name for incoming Connection #1 enter "#1:table1". Finally, leave the Spatial tab options all blank.
For the tabluea input tool you must configure it as follows: