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
0 answers

Alteryx for Statisticians- to use or not to use?

Is anyone a statistician and using alteryx? I’m wondering if anyone has experience with this or anything to say regarding statisticians using alteryx versus SAS or R. Also, If so, is there a way to conduct statistical tests writhing alteryx.
Chris B
  • 11
  • 1
1
vote
3 answers

Method/tool for determining the distance between locations

I work for a healthcare company and have information on patient's location (address, city, state, zip). I am trying to determine what percentage of patients live closest to 5 specific locations. The answer I'm looking for would be something like…
anddon
  • 15
  • 5
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
0 answers

Alteryx & tableau - OCILogon2 Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

I have two database servers Test and Prod. I installed all the oracle client tools required for establishing connections. I am able to connect to both of Test & PROD using basic connection type from SQL developer. Also I am able to connect to the…
Pdata
  • 31
  • 8
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
  • 453
  • 1
  • 8
  • 23
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
  • 41
  • 1
  • 7
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
  • 2
  • 8
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
  • 4
1
vote
1 answer

Excel Dynamic Table with Data from Another Sheet

I am trying to create a table of dynamic range that takes data from another sheet. The short story is that I need to do this because Alteryx will drop an old existing sheet of the same name when uploading new data each time that it is ran. I am…
courtrhale
  • 19
  • 1
  • 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
  • 1,321
  • 2
  • 18
  • 44
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

Alteryx : How to remove columns with specific names?

I am trying to figure out how to remove a column with a specific name when i read a excel TSV in Alteryx? Below is the sample tsv data that i have received name given_name family_name email default_email_language id deactivated blocked…
desmond.carros
  • 372
  • 2
  • 21
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
  • 1,148
  • 6
  • 20
  • 43
1 2
3
…
17 18