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 count occurrence of different features on a category in Qliksense and output a bar graph?

I am quite new to Qlik and I am trying to make a measure that counts different categories for outputing a bar graph with the count of each category on said graph. Anyone know how to do this? Right now I am processing the raw data on Alteryx to…
tiagoeng
  • 1
0
votes
1 answer

Dataframe tolist adds [] or the dataframe reads header while going through a for loop. How can I get the list to work in the for loop?

I'm using an import from an Alteryx data flow, which is a single column that contains the following integer format: Reading the data in from alteryx converts it to a dataframe automatically. searches = Alteryx.read("dataimport") SUCCESS: reading…
user1470034
  • 671
  • 2
  • 8
  • 23
0
votes
0 answers

Alteryx workflow using python

I am a newbie in Alteryx - has anyone ever built an etl workflow using python? I know how to read and run the jupyter notebook through import script in alteryx menu but not sure how to run my code as multiple steps of workflow. Any ideas?
Mori E
  • 11
  • 4
0
votes
1 answer

Resource Error when connecting dremio to Alteryx

I've data that is on Dremio and I'm looking to connect it with Alteryx. It was working fine until once I had cancelled the Alteryx workflow in the middle of the execution. After that that instance - it is always giving the below error which I'm not…
Mishal
  • 450
  • 9
  • 27
0
votes
1 answer

Regex to extract multiple numbers with decimal

I have the following group of numbers: SalesCost% Margin 2,836,433.182,201,355.6422.39 Expected Result: I want to separate this and extract the numbers such that I get the result as shown below: 2,836,433.18 2,201,355.64 22.39 Attempt I tried the…
Dpak
  • 41
  • 2
0
votes
2 answers

Writing csv with double quotes around strings (Alteryx)

I need to create a csv file with Alteryx on Azure Datalake Gen2, reading from a table which has a string field that might contain commas. I'm using the "Azure Data Lake File Output" connector in the Alteryx flow (which, as far as I know, does not…
panda
  • 163
  • 2
  • 9
0
votes
2 answers

How to combine two files in Alteryx

i am learning Alteryx and have ran into my first issue. I have an excel file that i am using as one source. The files has two sheets with the same data, but the second sheet does not have headers. I wanted to see if there was a way to combine the…
Josh Hudson
  • 103
  • 1
  • 10
0
votes
0 answers

How to fix parse error when missing data from the input source in Alteryx?

I am quite new to data analytics, SQL and Alteryx. I have a workflow that is getting a parse error, because the fields are missing from the input source data. I need to add the rows in with no values to prevent the error. I'm wondering if adding a…
DBlack
  • 1
  • 1
0
votes
1 answer

Snowflake Insert/Update Error in Alteryx "Primary Key required for update option"

Having some issues updating a Snowflake database by inserting/updating records based on a primary key. Getting this error below: enter image description here My set up: I have set a primary key in the Snowflake DB "PRIMARY_KEY", using the…
Akihiro Komatsu
  • 1
0
votes
1 answer

Why won't my alteryx R and Rstudio pull from the same package library?

I am getting an error telling me I don't have packages when trying to use tidycensus in R/Alteryx. This works fine in Rstudio? Does anyone know how to change alteryx directory to match rstudio for calling…
MJ_215
  • 13
  • 2
0
votes
1 answer

Can I connect Alteryx to CosmoDB

I have a project where my end users are using Alteryx to combine data sources and import into SQL server. We are investigating changing SQL server to CosmoDB but I'm not sure if connecting to CosmoDB is supported by Alteryx. Do anyone know if there…
Russ
  • 12,312
  • 20
  • 59
  • 78
0
votes
2 answers

Alteryx: Create several rows from a range in a string

I'm looking for a way to use Alteryx for the following data wrangling task. I have a table like this: Var1 Var2 A 1-3 B 0-2 and I would like that to result in this: I have a table like…
ulima2_
  • 1,276
  • 1
  • 13
  • 23
0
votes
1 answer

How to use Powershell Compress-Archive to compress only pdfs in a folder?

I'm working on an Alteryx workflow which creates multiple pdfs and outputs them to a directory. I need to call a Powershell script at the end of the workflow to compress the pdfs into a zip file and save it in the same location. I found…
bourgeoisna
  • 95
  • 1
  • 11
0
votes
2 answers

Need to extract specific text from a column on excel using either Alteryx or Pandas

I have a column that contains a specific set of text that I need to be retained and the rest removed or moved to another column. Unfortunately, I am not able to use normal text-to-column due to the variation of the text arrangement. For example, I…
hoss1186
  • 51
  • 2
0
votes
1 answer

How to group by ID and find gaps in dates to determine start and end date in Alteryx?

I have a dataset that looks like the following; ID Date 1 2018-07-23 1 2018-07-24 1 2018-07-25 1 2018-07-26 1 2019-12-31 2 2020-01-01 2 2020-01-02 2 2020-01-03 2 2020-01-06 2 2020-01-07 What I am trying to achieve is…
craig3656
  • 41
  • 4
1 2 3
…
17 18