Votes
Answers
Views
Question
4
votes
1
answer
153
views
asked 3 years ago by
updated 3 years 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 there are some null values in records that also have data. Is there a way to quickly remove these entir...
4
votes
1
answer
84
views
asked 3 years ago by
updated 3 years 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 on the regular join tool, it does not. How would I go about accomplishing each of these joins?
4
votes
1
answer
24
views
asked 3 years ago by
updated 3 years 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 characters every time and I need the periods and the same place every time. So I need: Before: 12345678901234...
4
votes
1
answer
72
views
asked 4 years ago by
updated 4 years 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 because there are only fields A and B. If any fields (in this C and D) are not present it means there is...
4
votes
1
answer
40
views
asked 4 years ago by
updated 4 years 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
116
views
asked 4 years ago by
updated 4 years 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
651
views
asked 4 years ago by
updated 4 years 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 am only getting 'A' as a result. How can I filter on multiple values?
4
votes
1
answer
198
views
asked 4 years ago by
updated 4 years 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 name for each of these files?   Thanks.
1
vote
1
answer
215
views
asked 3 years ago by
updated 3 years ago by
Category: Data Analytics
I installed a new version of Alteryx, and now I'm missing a bunch of my Parse, In-Database, Reporting, Documentation, Interface, and Data Investigation tools! Do I need to go out to the Alteryx Gallery and download them for some reason?  How do I get these back?
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top