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

Trying to separate the year month and day fields via RegEx

I have a series of dates that I am trying to separate into years, months and days. These dates are in the yyyy-mm-dd format. I'm not very familiar with RegEx, but I have tried (\dddd)\-(\dd)\-(\dd). Any help is appreciated.
Brad Lee
  • 187
  • 1
  • 10
-1
votes
1 answer

How to exclude delimiters inside text qualifiers using Regex?

I am trying to exclude delimiters within text qualifiers. For this, I am trying to use Regex. However, I am new to Regex and am not able to fully accomplish my needs. I would be very greatful if someone can help me out. In Alteryx, I load a…
Robin
  • 1
  • 4
-1
votes
1 answer

Copy tables from one database to another using Alteryx

I have a list of tables that need to copied from one database to another. The list of tables resides in the table in a DB. I am trying to write a Standard Macro to perform this. This is what I have so far: The macro reads the in list of tables and…
Saqib Ali
  • 3,953
  • 10
  • 55
  • 100
-1
votes
1 answer

Use Salesforce API to extract data into Alteryx

I have an Alteryx workflow and wanted to hook it up to import data from Salesforce, specifically Veeva (which sits on Salesforce). I want to use the Salesforce API but not sure how I can do this simply with Alteryx. Is it possible to use Alteryx…
GermanGrandson
  • 1
-2
votes
1 answer

Can a regex point to a list to find matches

Im currently using a Regex procedure in Alteryx to recognize an employee number in a PDF document and split the document into individual pdfs based on ee number. RegEx in alteryx flow Essentially what it does is find the term "Employee" on each…
David Smyth
  • 1
-2
votes
2 answers

Right Join Not Including Null Rows

Hoping someone can help me with this. I am rewriting an Alteryx Workflow into SQL and in the workflow there is a left, inner and right join. When I write my sql to replicate the left and inner join I get the same number of records as the Alteryx…
GiantPencil
  • 1
-2
votes
1 answer

Alteryx - Split a string with an uncertain length into 5 characters per column

I am trying to split a string (the string length is uncertain; it could be 500 characters or 1500 characters) into multiple columns, and each column should only contain 5 characters. For example, If column A contains the…
Beans
  • 139
  • 5
  • 19
-2
votes
1 answer

How can I list files name using this python code?

I use the python code below which runs inside an Alteryx workflow. I would like to add a column so that it could list all files that are inside those folders. Any idea of how I can add this information to the code below? from ayx import…
Jackeline Roseno
  • 1
-2
votes
2 answers

Regex extract number from a string with a specific pattern in Alteryx

I have string like this which looks like a url mainpath/path2/abc/PI 6/j From the string I need to get the number along with PI Main problem is the position of PI part wont be always the same. Sometimes it could be at the end. Sometimes at the…
Sandeep Thomas
  • 4,303
  • 14
  • 61
  • 132
-2
votes
1 answer

compare performance between spark and alteryx

I know spark but new to alteryx.Can anybody throw some light on my below question. compare on basis of performance for spark and alteryx? Also what exactly present in alteryx,that it do ETL job in seconds(read)?
sparken
  • 11
  • 2
-2
votes
1 answer

Regex - Alteryx - Parse - How to find an expression starting by the end of the string

I need to parse the following expression: Fertilizer abc 7-15-15 5KG BOX 250 KG in 3 fields: The product description: Fertilizer abc 7-15-15 Size: 250 Size unit: KG Do not know how to proceed. Please, any help and explanation?
PMig
  • 13
  • 4
-2
votes
1 answer

Alteryx - Pattern recognition on numeric data

I have a set of test results for a list of products over a period of time. I need to create a Alteryx workflow that can recognize the signal of the numeric data - up, down, flat - this will lead to a pattern recognition on the data to evaluate…
lchester
  • 71
  • 1
  • 4
-2
votes
2 answers

How to check if value from one column exist in the second column in Alteryx

I have some values in column A and I want to check one by one if the values in column A exist in column B.
Rohit Kumar Singh
  • 647
  • 1
  • 7
  • 17
-2
votes
3 answers

Regexp to match Captial cases in address Pattern

I want a regular expression to find addresses having mixed characters that can be used in Alteryx. The first example has capital cases in the beginning and second one in between. IFBDAGE,Place des Augustins 19,Bonita Springs 28/10 Macquarie…
MKrishnaPillai
  • 1
-3
votes
2 answers

Regex custom form

I have this statement: Credits Electronic deposits/bank credits Effective Posted date date Amount Transaction detail 07/01 2,023,825.24 Stagecoach Sweep Credit 07/02 2,023,825.24 Stagecoach Sweep Credit 07/02 19,479.00 WT Fed#02868 E Trade…
jjj
  • 35
  • 1
  • 8
1 2 3
…
17
18