Questions for tag "alteryx" (9)

Votes
Answers
Views
Question
4
votes
1
answer
2
views
asked 1 week ago by
updated 1 week 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
4
views
asked 2 weeks ago by
updated 2 weeks 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
4
views
asked 3 weeks ago by
updated 3 weeks 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
7
views
asked 3 weeks ago by
updated 2 weeks 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
6
views
asked 1 month ago by
updated 1 month 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
10
views
asked 1 month ago by
updated 3 weeks 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
7
views
asked 1 month ago by
updated 1 month 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
25
views
asked 4 months ago by
updated 4 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 ...
5
votes
1
answer
13
views
asked 4 months ago by
updated 4 months ago by
Category: Data Analytics
I am wrapping up a project with multiple workflows and many inputs/outputs. I need to change all of the paths to be relative, however doing this by hand will take hours. Is there a way to do this quic...