Questions for tag "alteryx" (16)

Votes
Answers
Views
Question
4
votes
1
answer
1
view
asked 18 hours ago by
updated 18 hours 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
14
views
asked 2 weeks ago by
updated 2 weeks 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
6
views
asked 3 weeks ago by
updated 3 weeks 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
9
views
asked 1 month ago by
updated 1 month 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
6
views
asked 1 month ago by
updated 1 month 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
3
views
asked 1 month ago by
updated 1 month 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
6
views
asked 2 months ago by
updated 2 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
8
views
asked 3 months ago by
updated 3 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
12
views
asked 3 months ago by
updated 3 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
8
views
asked 3 months ago by
updated 3 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
17
views
asked 3 months ago by
updated 3 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...
1
vote
1
answer
12
views
asked 3 months ago by
updated 3 months ago by
Category: Data Analytics
For example, will 'marketing' from one input join with 'MARKETING' from another input or not? If not, what is a quick work around to get them to join properly?
1
vote
1
answer
15
views
asked 4 months ago by
updated 3 months ago by
Category: Data Analytics
When using the join tool in Alteryx, are the fields used case-sensitive?  Do they have to be uppercase or lowercase?
4
votes
1
answer
9
views
asked 4 months ago by
updated 4 months ago by
Category: Data Analytics
Hi. I'm new to Alteryx and built a macro that saved as a .yxmc file. I see it in my file explorer, but I am unsure of how to quickly insert it into my workflow. I don't see it anywhere on the toolbar!...
4
votes
1
answer
53
views
asked 7 months ago by
updated 7 months ago by
Category: Data Analytics
The Sample tool allows you to select the First N Rows, Last N Rows, and Skip 1st N rows, but is there a way to use this tool to skip the last N number of rows? I know that this can be accomplished by ...