Votes
Answers
Views
Question
4
1
243
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
198
Tags:
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 name for each of these files? Thanks.
4
1
155
Tags:
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 there are some null values in records that also have data. Is there a way to quickly remove these entir...
4
1
116
Tags:
Is it possible to add comments within the formula tool? If so, how can I accomplish this? Thanks!
1
1
102
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?
4
1
87
Tags:
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 on the regular join tool, it does not. How would I go about accomplishing each of these joins?
4
1
72
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...
0
1
49
Tags:
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 no combination of transpose/cross tab seems to get it looking how I want. What am I missing?
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!