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

Ignoring a delimiter in a string between ()

In Alteryx I need to parse a string that is ; delimited, but the data is constructed in a way that there are extra ; between brackets () when there are multiple outputs. I found this expression for RegEx (;)+(?![^{]}) which would work if the ; was…
MattWD
  • 1
  • 1
0
votes
2 answers

SQL - Automatically adjust Where clause to previous month in YYYY-MM format

(This is all steps in containers within an Alteryx flow that is connecting to a Teradata source) My SQL is incredibly rusty as it's been almost 8 years since I've needed to use it. I know this is a quite basic question. Basically I have several…
fruehling
  • 1
  • 1
0
votes
1 answer

R - Alteryx - All columns in a tibble must be vectors

I'm using R on Alteryx to perform some statical analysis from my data. It appears the error message " ! All Columns in a tibble must be vectors." as the following error message: Does anybody can help me? Below is my entire…
Wil
  • 47
  • 4
0
votes
0 answers

File Browse in Alteryx - New File Selected when it is run

I'm somewhat new to Alteryx, and I'm stuck on inputting excel files correctly. My goal is to utilize the File Browse tool so that the user of the app/workflow can select/input a new file when it is run. While the files inputted may differ each time,…
Jay
  • 41
  • 4
0
votes
1 answer

Dynamically rename header to 1,2,3,4,5

Im trying to remame the columns in the table below with ascending integers. The dates will change week on week, so I need a way to dynamically rename in alteryx, is there a way of doing this with the dynamic rename tool? or another method…
shazma
  • 55
  • 6
0
votes
0 answers

0 Records exist Alteryx, even though data exists

I have a couple of excel files I want to load into Alteryx, I can see in the preview that records exist, when I run the flow it says 0 records displayed, as below Any ideas? Thanks
shazma
  • 55
  • 6
0
votes
1 answer

XML Encoding Character Error when trying to Open in ALteryx

I am using alteryx to edit an xml file and only replacing 5 numbers out of the whole 25k line file and everything is exactly the same but I get these characters in black on the left in for some reason when I export. I kept everything the same export…
Jimmy6In
  • 1
  • 4
0
votes
1 answer

How ETL tool Fast Load to SQL Server?

When I use Fast Load to SQL Server from ETL tool like SSIS or Altery I see below running on SQL Server insert bulk (Column1 datatype, Column2 datatype, ......., column datatype) with (TABLOCK, ROWS_PER_BATCH = 418397672,…
Pritesh
  • 1,938
  • 7
  • 32
  • 46
0
votes
1 answer

Converting File into XML Format

Hello I have an Alteryx workflow that I edited and it was in XML format before, only problem is I didint have the option to export in XML. There is a multitude of choices but went with the FLAT file since it looks close (let me know if there is a…
Jimmy6In
  • 1
  • 4
0
votes
1 answer

Produce weekly and quarterly stats from a monthly figure

I have a sample of a table as below: Customer Ref Bear…
shazma
  • 55
  • 6
0
votes
1 answer

Beginner - Convert dataframe to rows of strings

I'm totally new to python. I am trying to use the azure.servicebus module. https://pypi.org/project/azure-servicebus/ I generate rows of json strings, that I want to pass to the servicebus. If I have 2 or more rows, it works.If I only have 1 row, it…
Dennis Schlein
  • 25
  • 4
0
votes
1 answer

regular expression help for parsing in alteryx

I have a string (without doble qoutes) "2022-12-15 21:23:22 - a123456 (Remarks) 2022-12-15 22:12:22 - a123456 (Remarks) User acknowledgement time" There are 2 date/time stamps in this string in need the date/time stamp appearing before User…
Mkh
  • 1
0
votes
0 answers

Use task scheduler to trigger Alteryx when computer is locked with Powershell

I am looking to run an Alteryx file with powershell through task scheduler in Windows 10. I have everything working, when the computer is unlocked, since I can send keys, however when the computer locks, sendkeys does not work and my script…
Lowpar
  • 897
  • 10
  • 31
0
votes
1 answer

Unable to figure out which npm dependency to resolve

I am trying to create a tool in Alteryx, using python. I am following the steps outlined in their guide, and am facing a problem which is specific to npm. I have looked around on how to solve this, but don't understand which dependency needs to be…
python_amateur
  • 1
  • 3
0
votes
0 answers

Alteryx Tool to Remove JSON Key/Value Pairs or Transpose JSON

I have ingested a JSON file from Azure Data Lake using the Azure Data Lake File Input tool. I would now like to make some changes to the fields or should I say key/value pairs. In order to make the changes, I would like to convert the JSON to a…
Patterson
  • 1,927
  • 1
  • 19
  • 56
1 2 3
…
17 18