Stack Overflow
Stack Overflow

Questions tagged [alteryx]

Alteryx provides an easy-to-use analytics platform for enterprise companies making critical decisions that drive their business strategy and growth.

From Why Alteryx, Alteryx provides an easy-to-use analytics platform for enterprise companies to do self-service data analytics.

References

270 questions
1
vote
2 answers

RegEx Parse Tool to extract digits from string

Using Alteryx, I have a field called Address which consists of fields like A32C, GH2X, ABC19E. So basically where digits are pinned between sets of letters. I am trying to use the RegEx tool to extract the digits out into a new column called…
al_sweets
  • 136
  • 10
1
vote
1 answer

Regex for extracting key-value pair from HTTP Query String

I am using a data analysis package that exposes a Regex function for string parsing. I am trying to parse a response from a website that is in the format... key1=val1&key2=val2&key3=val3 ... [There is the possibility that the keys and values may…
Steve Hibbert
  • 2,045
  • 4
  • 30
  • 49
1
vote
2 answers

Can Alteryx workflows be triggered by changes in a database?

I need to check for any new tables in a particular database and trigger Alteryx if there is one. The contents of the new table will have input parameters that Alteryx should be able to read. I'm not sure if this is possible or not, so any help would…
Avantika Dasgupta
  • 83
  • 6
1
vote
0 answers

Lag function in Time series using R tool in Alteryx not working

I am trying to use 'Lag' function in R tool of Alteryx. I have copied my R code from R studio to R tool in Alteryx. After I create the first time-series using TS function, I want another series to be a lag series of the previous one. I tried 'lag'…
Sanket Saxena
  • 31
  • 2
1
vote
1 answer

RegEx for removing company suffix and keep original, or positive lookahead?

I am currently trying to do some natural language processing for company names. The regex I wrote is -\s+\w+('\w+|\s+\w) this is to remove all the text after the hyphen if its whitespace. Next, I then [.,/#!$%\^&*;:{}=-_`''"<>|~()] remove all…
Jenobi
  • 368
  • 4
  • 12
1
vote
2 answers

Survey Monkey- Custom Values via API v3

I am currently unable to figure out how to obtain several custom fields via the API. The Excel extracts provide the columns I need, but I cannot find a v3 GET or POST protocol to obtain the desired…
Drew Weaver
  • 21
  • 3
1
vote
2 answers

Survey Monkey API- Getting Long Lived Access Token

I am currently unable to figure out how to obtain my long-lived access token so I can create an API data feed from Survey Monkey to Alteryx. Thus far I have been able to: 1) Go to the OAUTH page https…
Drew Weaver
  • 21
  • 3
1
vote
1 answer

Getting error 404 while using Alteryx Gallery default URL

I have installed Alteryx server in my Windows based 2008 R2 server But I am not able to use default Gallery Url http://localhost/gallery/ getting error code-404
Kuldeep mathur
  • 11
  • 1
1
vote
1 answer

How to access weather data from all the stations in one country using openweathermap?

I am using Alteryx to extract weather data for a handful of cities and it works great. I'd like to expand this to able to download data for all weather stations in the UK. At the moment I am specifying which cities I want, e.g. London / Manchester.…
MyFamily
  • 145
  • 8
1
vote
3 answers

How to generate SQL query from Alteryx

Simple question - how can I view the SQL query that alteryx is using to run my workflow? I've googled and found info about a 'dynamic output' node, but I can't find that node in alteryx - it might be in a previous version?
jdjohnson920
  • 57
  • 2
  • 5
1
vote
2 answers

Why is this Formula for Alteryx returning 0's instead of averages

I was wondering what is wrong with the following formula. IF [Age] = Null() THEN Average([Age]) ELSE [Age] ENDIF What I am trying to do "If the cell is blank then fill the cell with the average of all other cells called [Age]. Many thanks all!
Zack Withrow
  • 125
  • 1
  • 2
  • 11
1
vote
1 answer

Why am I getting different output from the Alteryx R tool

I using the Alteryx R Tool to sign an amazon http request. To do so, I need the hmac function that is included in the digest package. I'm using a text input tool that includes the key and a datestamp. Key= "foo" datastamp= "20120215" Here's the…
Mutuelinvestor
  • 3,384
  • 10
  • 44
  • 75
0
votes
0 answers

Alteryx installation triggering dependency confusion attack alerts with ORCA

I have an instance of Alteryx Designer installed on a VM hosted in Azure. Recently, I have been using ORCA for cloud security and have been receiving an alert about a potential NPM and PyPi dependency confusion for the following…
Parker.V
  • 94
  • 8
0
votes
0 answers

Alteryx Python not Calling ii_init and ii_push_record

I'm working on an AlteryxPythonSDK Tool to process PDFs and extract tables from them. The plugin consists of an XML configuration, an HTML user interface, and a Python script. Despite implementing the necessary methods, I'm facing an issue where the…
Xplosio
  • 13
  • 2
  • 7
0
votes
1 answer

How do I complete this SQL code in Alteryx with the formula tool without directly selecting from the table?

SELECT *, LAG(orderdate, 1, NULL) OVER (PARTITION BY fullaccountnum, cin ORDER BY orderdate) AS previous_orderdate FROM table.revenue_invoice_data I've tried the expression below in the formula tool to no avail. I keep getting the…
Victor Marshall
  • 11
  • 1
1 2 3
…
17 18