Votes
Answers
Views
Question
4
1
136
Tags:
Is it possible to add comments within the formula tool? If so, how can I accomplish this? Thanks!
4
1
40
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
1
90
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 because there are only fields A and B. If any fields (in this C and D) are not present it means there is...
4
1
261
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, 5 When I use the Unique tool I get 1, 2, 3, 4, 5 on the U anchor and 1, 4, 4 on the D anchor. Is th...
4
1
386
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
1
2389
asked 4 years ago by Alteryx Training
updated 4 years ago by Charles Coleman
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 or something else?
1
1
119
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
1
1646
asked 4 years ago by Alteryx Training
updated 4 years ago by Charles Coleman
Category:
Data Analytics
Tags:
When using the join tool in Alteryx, are the fields used case-sensitive? Do they have to be uppercase or lowercase?
4
1
50
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! Please help!