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
6
votes
3 answers

Facebook Ads Insights API: (#3) Application does not have the capability to make this API call

I am trying to pull Facebook Ads metrics through the Facebook Marketing API. The flow is basically that I wish to pull all the account ids of my company, and then loop over them, retrieving the insights for them individually. However I have an…
caz777
  • 101
  • 1
  • 1
  • 6
4
votes
2 answers

Open Alteryx .yxdb file in Python?

Is there a way to import .yxdb (Alteryx database files) into Pandas/Python, without using Alteryx as a go-between?
user1566200
  • 1,826
  • 4
  • 27
  • 47
4
votes
5 answers

Is Alteryx an ETL tool? How it differs from SSIS?

My client want me to implement ETL process using Alteryx as they have a license of it. I am confused whether the Alteryx is an ETL tool or not. I believe that Alteryx is commonly used to prepare data for Tableau data visualization tool. Please…
Harry
  • 67
  • 1
  • 1
  • 4
3
votes
2 answers

Regular expression using positive lookbehind not working in Alteryx

I am trying to match a string the 2nd word after "Vores ref.:" using positive lookbehind. It works in online testers like https://regexr.com/, but my tool Alteryx dont allow quantifiers like + in a lookbehind. "ABC This is an example Vores ref.:…
Andreas Hjortberg Meyer
  • 33
  • 2
3
votes
4 answers

AUTOINCREMENT primary key for snowflake bulk loading

I would like to upload data into snowflake table. The snowflake table has a primary key field with AUTOINCREMENT. When I tried to upload data into snowflake without a primary key field, I've received following error message: The COPY failed with…
knozawa
  • 223
  • 1
  • 5
  • 14
3
votes
4 answers

Merge two CSV and collate data

I have two CSV files, the first like…
A New Guy
  • 31
  • 1
3
votes
1 answer

Alteryx - How to Process Sharepoint input which has Drop down list values

I would like to read Sharepoint data which contains attributes for a dropdown list. I am connecting to Sharepoint using the Alteryx's Sharepoint list connector tool. Alteryx is only returning the data that is already selected from the dropdown. It…
Padmanabhan Vijendran
  • 306
  • 1
  • 6
  • 18
3
votes
2 answers

_x000D_ appearing when importing into SQL

I am importing some Excel spreadsheets into a MS SQL Server. I load the spreadsheets, cleanse the data and then export it to SQL using Alteryx. Some files have text columns where the cells span multiple lines (i.e. with new line characters, like…
Pythonista anonymous
  • 8,140
  • 20
  • 70
  • 112
2
votes
1 answer

Using Python Script to run an Alteryx workflow via the Microsoft Task Scheduler on Remote Desktop

my python script works perfectly fine as long as I'm logged into the remote desktop while the task scheduler initiates it. However, if I'm no longer connected to the remote desktop, it terminates because pyautogui has a Failsafe. When I turn the…
KeyaD77
  • 21
  • 6
2
votes
1 answer

Is there a Regex to trim numbers after two decimal places?

I am trying to reduce the number of decimals and for some reason, using a "fixed decimal" 258.2 does not change all numbers in my column to two decimal places. Pretty much I have the following after specifying the number as a fixed decimal with 2…
Jfha97
  • 41
  • 4
2
votes
3 answers

How to convert a date into the nth day of the week in Alteryx or Python?

If I have a column of dates filed like the below; Date 2021-08-01 2021-08-02 2021-08-03 2021-08-01 2021-08-02 What I wish to do is add a new column that will tell me the number of mondays for example that the date is in the year. so I can see that…
craig3656
  • 41
  • 4
2
votes
0 answers

Ignore Specific Types of Changes with Github

I am relatively new to GitHub and I am primarily using it for Python development, but also a little of Alteryx for VC purposes. Alteryx loves creating/changing temp files, so everytime I save the workflow, I get dozens of changes that aren't…
Andrew Cooper
  • 31
  • 1
2
votes
0 answers

C to Go: Is this long execution time caused by CGO overhead?

I am trying to write an SDK that lets me build custom Alteryx tools in Go. Alteryx provides a C API for these custom tools. I have been able to use cgo to connect Golang code to the Alteryx engine. However, when I compare with a similar Python…
Tom Larsen
  • 21
  • 2
2
votes
1 answer

Creating automated Tableau packaged workbooks (for Tableau Reader) using Alteryx TDE output

I am running an Alteryx workflow on a dedicated PC, 4X a day. The Alteryx workflow creates a TDE output file that is the data source for a dashboard I would like to save as a packaged workbook (openable in Tableau Reader) and distribute 4X a day. I…
Kersi Shroff
  • 21
  • 1
2
votes
1 answer

Do Temporary Stored Procedures Use Global Temporary Tables?

I'm trying to troubleshoot an error that I'm getting when I try to insert/append into an Azure SQL database. The error I'm getting: Error: Write Data In-DB (353): Error running PreSQL on "NoTable": Microsoft OLE DB Provider for SQL Server: An…
Mutuelinvestor
  • 3,384
  • 10
  • 44
  • 75
1
2 3
…
17 18