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

198 questions
1
vote
1 answer

Adding information from a smaller table to a large one with Pandas

I would like to add the regional information to the main table that contains entity and account columns. In this way, each row in the main table should be duplicated, just like the append tool in Alteryx. Is there a way to do this operation with…
ba90343
  • 11
  • 1
1
vote
2 answers

Opening Alteryx .yxdb files in R

Similar to the question below, I was wondering whether there is a way to open .yxdb files in R? Open Alteryx .yxdb file in Python?
Egodym
  • 431
  • 1
  • 6
  • 19
1
vote
2 answers

Regex to match everything between multiple set of brackets

I am trying to match everything between multiple set of brackets Example of data [[42.30722,-83.181125],[42.30722,-83.18112667],[42.30722167,-83.18112667,[42.30721667,-83.181125],[+42.30721667,-83.181125]] I need to match everything within the…
anonymous13
  • 399
  • 3
  • 9
1
vote
1 answer

Not able to generate X Coordinates and Y coordinates Via using Formula

I am trying to create X and Y coordinates in Excel based on my first column which is 1- 100. I am not able to achieve the desired result.Attached Screenshot I have only 1 column which is Path and based on that I need to derive X and Y. Note :…
Rajeev Pandey
  • 19
  • 5
1
vote
3 answers

Running Alteryx flows from command line

I'm trying to figure out if I can launch a pre-built Alteryx workflow without launching the Designer - and without having Alteryx Server. I came across a helpful post on Alteryx uses by @Runonthespot that, among other things, addressed running…
LBerg
  • 33
  • 7
1
vote
2 answers

How to convert nvarchar(254) to decimal(7,2)

I have a table with 10M+ rows and want to change the data type of one the columns from nvarchar(254) to decimal(7,2). What is the most efficient and effective query to make this change? I have tried using ALTER in order to make this change, but get…
dallen93
  • 11
  • 3
1
vote
2 answers

Regexp to match only first occurrence starting from top of the text

I'm working on extracting specif string set after matching a pattern but results are not as expected. Instead of first occurrence starting from top of the text file the function picks very last…
marcin2x4
  • 619
  • 3
  • 13
1
vote
0 answers

Associate An Income Amount to a Specific Outgoing Amount

I hope you are well. I have been given a very specific set of data and I need to associate outgoing financial amounts to incoming ones on a first-in-first-out basis. I need to be able to determine in a stack-like fashion which incoming transaction…
Shaun Avalon
  • 13
  • 1
  • 4
1
vote
1 answer

Heavily unbalanced/skewed data clusters

I am facing some issues with my k-means clustering results on Alteryx. I am trying to conduct topic modelling on my data set of around 5000 text descriptions. After data cleaning, parsing and removing stop words and common words, I created a…
Adrian
  • 23
  • 4
1
vote
0 answers

Recovery Time Calculation Supply vs Demand

I have a scenario where I am comparing the output of an item to its required output which is done weekly. I calculate the percentage of actual output against required output which can be seen in the Requirement Met % row below. Where I'm…
TechCowboy
  • 51
  • 8
1
vote
1 answer

Out of memory errors while using Alteryx and PostgreSQL

I'm getting "Error SQLExecute: out of memory for query result" while trying to load a mid level database (10s of millions records). My Workflow is not doing anything that should cause it to store all the data in memory and the error appears to come…
Forbesmyester
  • 936
  • 6
  • 15
1
vote
1 answer

Connect Tableau to .SQL File on Desktop or SharePoint

Is it possible to have Tableau run a query that is stored in an external location such as SharePoint? If not, is Alteryx a tool with this particular capability? I have a central location for my queries (SharePoint), which allows multiple people to…
Torc
  • 628
  • 3
  • 12
  • 28
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
  • 1,721
  • 2
  • 24
  • 45
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
  • 5
1
2
3
…
13 14