Questions for tag "alteryx" (20)

Votes
Answers
Views
Question
4
votes
1
answer
7
views
asked 3 weeks ago by
updated 3 weeks ago by
Category: Data Analytics
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...
0
votes
1
answer
7
views
asked 3 weeks ago by
updated 3 weeks ago by Weston
Category: Data Analytics
I have a pretty simple problem and I can't find a simple solution. I basically just want to turn all my columns to rows and vice versa, and not keep headers. I thought this would be pretty simple but ...
4
votes
1
answer
6
views
asked 1 month ago by
updated 1 month ago by
Category: Data Analytics
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
20
views
asked 2 months ago by
updated 2 months ago by
Category: Data Analytics
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
15
views
asked 2 months ago by
updated 2 months ago by
Category: Data Analytics
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
42
views
asked 3 months ago by
updated 3 months ago by
Category: Data Analytics
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...
4
votes
1
answer
13
views
asked 3 months ago by
updated 3 months ago by
Category: Data Analytics
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
10
views
asked 3 months ago by
updated 3 months ago by
Category: Data Analytics
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
7
views
asked 4 months ago by
updated 4 months ago by
Category: Data Analytics
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
4
views
asked 4 months ago by
updated 4 months ago by
Category: Data Analytics
Is it possible to add comments within the formula tool? If so, how can I accomplish this?   Thanks!
4
votes
1
answer
11
views
asked 4 months ago by
updated 4 months ago by
Category: Data Analytics
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
12
views
asked 5 months ago by
updated 5 months ago by
Category: Data Analytics
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...
4
votes
1
answer
27
views
asked 5 months ago by
updated 5 months ago by
Category: Data Analytics
I have a field of numbers with the following values: 1, 1, 2, 3, 4, 4, 4, 5 I would like to generate an output which only contains the numbers which are NOT duplicated. My ideal output would be: 2, 3,...
4
votes
1
answer
18
views
asked 6 months ago by
updated 6 months ago by
Category: Data Analytics
I have data with the structure in the attached file. How can I make it look like the second file as concisely as possible? Whenever I try to use Crosstab tool it tries to sum or concatenate.
1
vote
1
answer
24
views
asked 6 months ago by
updated 5 months ago by
Category: Data Analytics
I'm trying to find the difference between two dates in Alteryx.  In Excel, I'd just subract one from the other, but I don't think that works here. Am I supposed to use datetimediff in a Formula tool o...