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

Python decorators (functools etc) in Alteryx Python Tool?

Does anybody know if there is a way to make use of python decorators like functools (@cache) for Python tool in Alteryx? Looking to implement a repetitive function evaluation in python and caching the results would save enormously. I have seen use…
Aadarsh Gupta
  • 29
  • 4
1
vote
1 answer

Alteryx Error generating JWT token with python tool - NotImplementedError: Algorithm 'RS256

I am having issues creating an Alteryx workflow that encodes a JWT token with the RS256 algorithm in the python tool. Here is my code: ################################# from ayx import Alteryx from ayx import Package import…
bocodes
  • 387
  • 1
  • 4
  • 12
1
vote
1 answer

Featuretools group by issue

I have a set of dataframes/entity set for rugby league/sports data: players, teams, venues, games, team_stats and player_stats players: player_id, player_name teams: team_id, team_name games: game_id, venue_id venues: venue_id,…
apapa2234
  • 11
  • 1
1
vote
1 answer

Parsing Data using Regex. Split it into columns via groups

I want to use REGEX to parse my data into 3 columns Film data: Marvel Comics Presents (1988) #125 Spider-Man Legends Vol. II: Todd Mcfarlane Book I (Trade Paperback) Spider-Man Legends Vol. II: Todd Mcfarlane Book I Spider-Man Legends Vol. II: Todd…
Benjamin Stringer
  • 41
  • 5
1
vote
1 answer

Matching Numbers that are Close in Value in Alteryx

I have two different datasets with different values in Alteryx. The one dataset serves as a lookup table for the other. For example: Name   Code Source ================== Al      124.5 A Bill    324.1 A Cody    947.6 A Dan    543.2 …
324
  • 702
  • 8
  • 28
1
vote
0 answers

Alteryx connection to Oracle database

I am trying to connect to oracle database through Alteryx. I keep getting the same error message as below: connection error im003 specified driver could not be found due to system error 126: the specified module could not be found. (simba oracle…
Leena
  • 247
  • 1
  • 7
1
vote
1 answer

How to convert IF statement into CASE statement?

I want to convert the following IF statement into CASE statement, since it doesn't work in Alteryx, which is using a Snowflake database. IF LEFT([SN],3)="CAT" AND Length([SN])=17 THEN RIGHT([SN],8) ELSE [SN] ENDIF Could you please help me?
Evoz
  • 23
  • 4
1
vote
1 answer

Create/Drop Tables in Athena using Alteryx Designer

is there way to drop and create tables in Athena from Alteryx Designer? I thought it would be dead simple using the connect In DB node and writing drop table test But I'm getting the following error Connect In-DB (3) Error SQLPrepare:…
Coopernicus
  • 85
  • 10
1
vote
1 answer

How to read a constant value like an email address into Email Tool

I am using an Email Address and have the email address hardcoded into the "To:" property, but prefer to move that email address as a custom workflow constant. What tool can I use to just read that constant value. Thanks in advance !
Mark C
  • 610
  • 2
  • 5
  • 15
1
vote
2 answers

Split string on certain words case insensitive using regex (alteryx)

If my string is: mary lamb The beast the castle THE large lake I want to produce: mary lamb The beast the castle The large lake If I do (?i)(?:(.*the)) then it only splits on the last the but i want to split on each "the" regardless of case.
BobsBugs
  • 11
  • 2
1
vote
1 answer

Using Regex Replace to remove duplicate numbers stored as string-Alteryx

Trying to remove duplicate numbers in the same cell in alteryx using regex replace due to applying to a large amount of columns. Below is my current formula. It is working for all rows except the last where the decimals are numbers are being…
arisophia
  • 61
  • 4
1
vote
1 answer

Using SQL, can I iterate through a table on a composite key to find specific data and compute new values?

If I have a data set with a composite key of an order number and a timestamp, can I iterate through the timestamps to search for data values at the specific time? For example, I would want to iterate through the specific order number until I find…
Andrew Scheidt
  • 11
  • 1
1
vote
1 answer

Alteryx REGEX upper first letter of every sentence and lower case for the rest

I'm trying to transform strings in Alteryx using one regex tool as follows Original: lorem ipsum. DOLOR SIT AMET. Looking for: Lorem ipsum. Dolor sit amet. Now, I did manage to match this pattern with the following REGEX (^\w)|\.\s(\w) But I'm…
Crowell
  • 35
  • 5
1
vote
1 answer

Snowflake is not recognizing a column in a table created in Alteryx

I have an Alteryx workflow which selects everything from a snowflake table, adds a RecordId column to the table, then uploads the result back to snowflake with a new name. The problem is: Snowflake does not recognize the RecordID column. If i use a…
ThePorcius
  • 123
  • 8
1
vote
1 answer

How can I produce this as a new column in an alteryx table?

Each row needs to be paired up with the one before it therefore I need a new column that looks like the following. flag 1 1 2 2 3 3 4 4 5 5 . . . and so on
craig3656
  • 41
  • 4
1
2
3
…
17 18