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

How to transpose and concatenate an auto-workflow on excel or alteryx

I have huge sets of data and addresses that run multiple lines. Trying to create a grouping function or tool on excel or alteryx that can transpose and group all of the data in a tabular format without selecting each group individually. Problem is…
AK7000
  • 1
  • 1
0
votes
1 answer

Alteryx Convert String to Time

I have a column of times in ALteryx like the following: Time ===== 8:05 AM 8:07 AM 8:11 AM 8:12 AM 8:16 AM ... They are currently stored as a String, but I want to convert them to the Time format. So far, I have tried using the LEFT and TRIM…
324
  • 702
  • 8
  • 28
0
votes
1 answer

What causes the Error: Naive Bayes Classifier (129): Naive Bayes Classification: Error: 'nresponse' is an empty string in Alteryx

I am try build a Naive Bayes Classifier in Alteryx and am attempting to pass through about 7,500 records however whenever I run the workflow I get the Error: Naive Bayes Classifier (129): Naive Bayes Classification: Error: 'nresponse' is an empty…
Christian
  • 1
0
votes
1 answer

How to extract character before last pattern using regex alteryx?

i would like to extract text before last item within brackets |Groupname| |---------| |Agile Transformation (FGH)| |Innovation Lab| from the raw data below using regex |Groupname| |---------| |Agile Transformation (FGH) (10000)| |Innovation Lab…
Jithin R.G
  • 1
  • 2
0
votes
1 answer

Matching multiple string values in two columns in Alteryx

Is it possible to compare strings in two different columns? I want to achieve something like this " If [field1] = [field2] ". My first thought is to use the filter tool but its a malformed statement. 
Morty2456
  • 1
  • 3
0
votes
1 answer

Generating Dates in Alteryx

Is there a way that I can generate dates between a Start and an End Date by using a RecordID as the Initialization Expression? The reason is because some of my data has duplicates whether that be the date or a different part of the data and I want…
alteryx_pilot
  • 1
0
votes
1 answer

Isolating same data in Alteryx workflow

I have a large set of data, however below shows only 4 entries. I want to isolate the rows that have the same entries. For instance, on table one you can see that the first two rows have the same value in the columns number, ID, Brand, and Partner.…
Morty2456
  • 1
  • 3
0
votes
1 answer

filtering multiple values based on one matching criteria in a different column in excel

I have the following set of data in excel that has transactions grouped by Set ID. I want to only view Set IDs that have at least one status1 of "Active" in the group. How do I identify these sets and remove the others that don't have at least one…
Analyst
  • 3
  • 2
0
votes
1 answer

Alteryx Designer - How to retrieve only first and last name from field excluding middle initials?

I need help in writing SQL code in Alteryx Designer. My table employees contains a column Name with values shown below. However, I need the expected output as shown below. Please help. Name: Smith, Mary K Koch, J B Batoon Rene, Anne S Vaughan-tre…
Anitha
  • 77
  • 1
  • 2
  • 9
0
votes
1 answer

try_to_date not a valid function within Alteryx SQL

After testing coding with snowflake, I implemented it within Alteryx's SQL builder and it doesn't acknowledge try_to_date as a function I am selecting a database column to convert to date - there are some however that are '00000000' which throws up…
PeachyJ
  • 1
0
votes
0 answers

How to append one excel file as a sheet onto another excel file in alteryx

so I have about 90 different excel files that are customer reports. I have one generic excel file that's a summary page that I need to insert as a sheet into all of those other excel files. Does anyone have a way to automate this process - I'm…
ankini
  • 1
0
votes
1 answer

Alteryx Rtool giving output failure

I am trying to output my wilcox test on Alteryx Rtool, but I am not suceeding. It appears a failure: "Error: R (12): Error in (function (..., row.names = NULL, check.rows = FALSE, check.names = TRUE, : " It runs OK on "R", but on Alteryx Rtool it…
Wil
  • 47
  • 4
0
votes
1 answer

Export customized excel report from Dataiku DSS

I have shifted from Alteryx to Dataiku DSS. Within Alteryx there is an option to format the excel output which can be exported to get custom report. I am unable to locate a similar functionality in Dataiku DSS. Could you please help or point me in…
NJ18
  • 13
  • 4
0
votes
0 answers

Creating a new column in PySpark, and indexing a row in the dataframe that returns a value 1 before

I have a pyspark dataframe that I am cleaning and it is based off of logic previously built into Alteryx. Inside the dataframe, you picture there being the following columns: col1 = 'Part', col2 = 'Tool' I am creating a new column called 'Fill' and…
Lucas Petrus
  • 11
  • 2
0
votes
1 answer

Azure key vault - Authorization header

I'm trying to use the API below to get access to a key vault. https://learn.microsoft.com/en-us/rest/api/keyvault/keyvault/vaults/get When I try to run this API in Alteryx, it asks for a authorization header. I'm not sure what information I need to…
Jackeline Santos BR
  • 11
  • 1
1 2 3
…
17 18