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
1 answer

Resolving 'ModuleNotFoundError' in Alteryx Python SDK: Implementing a Custom Tool in Alteryx Designer

I am developing a custom tool in Alteryx Designer and using the Alteryx Python SDK for the implementation. However, I am facing a ModuleNotFoundError when trying to import the AlteryxPythonSDK module. Here's my code: from ayx import Alteryx import…
usama nomani
  • 1
0
votes
1 answer

How can I find the mismatch between two similar PROD vs SIT datasets on a summary level and dive deeper into the row for inconsistencies? Alteryx?

I would like to automate this processes for multiple datasets. I am not sure if there exists a tool like Alteryx or any software where I can do the following. Compare 2 similar datasets on a block aggregate level. If mismatch exists, zoom into that…
sais
  • 21
  • 5
0
votes
0 answers

Output row number from dataframe after running through spacy

I'm working with the python tool in Alteryx to do some NLP with Spacy. I have some comments I want to extract noun chunks from, but I can't figure out which comments they are from and I'll have hundreds or even thousands of comments being…
user293775
  • 1
  • 1
0
votes
0 answers

How Handle Output tool when file is open - Alteryx

The issue is, I have some files in a shared folder, i am using Alteryx to refresh and update those files daily, some people work with those files and there are the situation: If anyone have some file open, the process cannot execute properly, and…
Daniel Mendoza
  • 33
  • 4
0
votes
0 answers

How to deal with a bad data from data analytic perspective

I have couple of columns (showing only two for reference) as shown below, Date Region Feb 2021 North america Jan 2021 South america Kinsley Norway here, you can see that the date column has a weird value instead of date…
KSp
  • 1,199
  • 1
  • 11
  • 29
0
votes
1 answer

How can I change a datetime value to a string, but keep the other values at Date value?

I'm dealing with a dateTime such as '1800-01-01 00:00:00' and I want to convert it to a string = 'N/A', but keep everything else as a dateTime. I tried converting it to a string (To_char(date_time)) AS date_time2 in a subquery and in the main query…
Carl Almasan
  • 1
0
votes
1 answer

Use the tables in Pbix file into Alteryx

I have a Pbix file in my c drive. I need to use the tables in the pbix in Alteryx. Please help me locate the ideal connection to use for this. Thanks
The King
  • 4,600
  • 3
  • 39
  • 58
0
votes
0 answers

alteryx workflow with python script

i have 2 python scripts which does excel automation task i need to use alteryx automation workflow including 2 python scripts, 1 python script is responsible for data preparation in excel and another script is reponsible to filling out the data from…
Bhavith Shetty
  • 1
0
votes
0 answers

Table or render tools outputting HTML into excel sheet

I am using designer version 2021.4.2. I am taking three separate files from my sharepoint library and pushing them to an excel. I want to format the output header names and background so have used the table tool. However, when outputting, it shows…
shazma
  • 55
  • 6
0
votes
0 answers

Does sequence in Alteryx Summarise tool matters?

I have 10 cols in Group by and 2 cols as Concatenate and one col as Max . I just want to know whether , Sequence 1: Col1 groupBy Col2 groupBy Col3 Concatenate Col4 Concatenate Col5 Groupby Col6 groupby Col7 groupby Col8 Max Col9 groupby And so…
AzSurya Teja
  • 121
  • 5
0
votes
0 answers

Created Python Script in Alteryx to dynamically join data from two sources

Hi all this is my first time posting here and my first time attempting to write Python so bear with the minimal knowledge I have! I am building this out within Alteryx and below is a screenshot of the "manual" join that the Alteryx flow currently…
llcode97
  • 1
  • 1
0
votes
0 answers

Data in email table body was changed in Alteryx when inputting the html file

I use Alteryx to process some data and then save it as a html file, as well as an Excel file. Then I input the html file (a table) as part of the email body and the Excel file as attachment, finally save an email draft file (eml file). Somehow, some…
qiao
  • 119
  • 7
0
votes
0 answers

Removing rows when a specific condition is met Python/Alteryx

Right now I have a database that auto updates every month with new Adjusted values for the prior month. However, the previous values are still in the database but they do not show as 'Adj' in the column name. Once a new month comes in I would like…
Ritchie
  • 1
0
votes
0 answers

How do I view Redshift db tables in Alteryx

I have a redshift database that I need to use as an import datasource. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection when testing it out. Yet, when I use this connection…
maria
  • 1
  • 1
0
votes
1 answer

How to implement Featuretools into my ML Process?

I am exploring the possibility of implementing Featuretools into my pipeline, to be able to create new features from my Df. Currently I am using a GridSearchCV, with a Pipeline embedded inside it. Since Featuretools is creating new features with…
Ali Kılınç
  • 11
  • 4
1 2 3
…
17 18