Votes
Answers
Views
Question
4
votes
1
answer
9
views
Tags:
I have a long series of digits (15) and I need to add three periods- one after the 5th character, one after the 9th, and one after the 11th. The field I want to update has the same number of character...
4
votes
1
answer
8
views
109868
Alteryx: Problems with Joins
Tags:
I am having difficulty understanding joins in Alteryx. I have used the in database tools primarily and it allows the user to specify what type of join they would like (left, right, inner, outer) but o...
4
votes
1
answer
39
views
Tags:
I have a large dataset that contains a select few records/rows that are null in every column. I would like to quickly remove these records, but I can't just filter on one particular column because the...
4
votes
1
answer
20
views
Tags:
I have a basic workflow and I am working on testing the data. There are roughly ten different .yxdb outputs, and I don't want to continue overwriting them while testing. I have been copying and pastin...
5
votes
1
answer
59
views
Tags:
I have always just used the Data Cleansing tool to fill in null values with zeroes. I have never really used the imputation tool and am not sure when or why it would be used, and what advantages it pr...
1
vote
1
answer
22
views
asked 5 months ago by Alteryx Training
updated 5 months ago by Charles Coleman
Category:
Data Analytics
I installed a new version of Alteryx, and now I'm missing a bunch of my Parse, In-Database, Reporting, Documentation, Interface, and Data Investigation tools! Do I need to go out to the Alteryx Galler...
4
votes
1
answer
15
views
Tags:
I am trying to change a field in the format 'yyyy-mm-dd hh:mm:ss' from a DateTime datatype to a Date datatype 'yyy-mm-dd'. I am accomplishing this in the Formula tool with Left([DateTimeField], 10) bu...
4
votes
1
answer
12
views
Tags:
I am trying to automate a process that reads in several xlsx workbooks. The sheet names on these workbooks change periodically so I cannot hard code the sheet names. Is there a way to get the sheet na...
4
votes
1
answer
8
views
Tags:
I am trying to use the Filter Tool and custom filter a column where it equals multiple values. I am using the following statement: [Field 1] = 'A' or 'B' or 'C' In the true output of the filter tool I...
4
votes
1
answer
6
views
Tags:
Is it possible to add comments within the formula tool? If so, how can I accomplish this? Thanks!
4
votes
1
answer
12
views
109671
Alteryx: Hotkey Shortcuts
Tags:
Hi. I'm new(ish) to Alteryx and I was wondering if people could share some of their most commonly used hotkey shortcuts. Thanks!
4
votes
1
answer
13
views
Tags:
I am scheduling a workflow that has new daily excel files. On day 1 there are fields A, B, C, and D. I aggregate on these fields in the workflow. On day two the workflow runs again, but error out beca...