Questions for tag "alteryx" (20)

Votes
Answers
Views
Question
4
votes
1
answer
14
views
asked 7 months ago by
updated 7 months 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
19
views
asked 7 months ago by
updated 7 months 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
20
views
asked 8 months ago by
updated 8 months 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
122
views
asked 9 months ago by
updated 9 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
33
views
asked 9 months ago by
updated 9 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
103
views
asked 10 months ago by
updated 10 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
78
views
asked 10 months ago by
updated 10 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
23
views
asked 10 months ago by
updated 10 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
22
views
asked 11 months ago by
updated 11 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
10
views
asked 11 months ago by
updated 11 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
16
views
asked 11 months ago by
updated 11 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
18
views
asked 1 year ago by
updated 1 year 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
51
views
asked 1 year ago by
updated 1 year 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
48
views
asked 1 year ago by
updated 1 year 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
153
views
asked 1 year ago by
updated 1 year 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...