Votes
Answers
Views
Question
4
votes
1
answer
146
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
80
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?
0
votes
1
answer
47
views
asked 3 years ago by
updated 3 years ago by Weston
Category: Data Analytics
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
votes
1
answer
21
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
308
views
asked 4 years ago by
updated 4 years 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 using Record ID, sorting and then skipping the first row, but I wasn't sure if there was a more conc...
5
votes
1
answer
317
views
asked 4 years ago by
updated 4 years 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 quickly?
1
vote
1
answer
2191
views
asked 4 years ago by
updated 4 years 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 or something else?
4
votes
1
answer
352
views
asked 4 years ago by
updated 4 years 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.
4
votes
1
answer
240
views
asked 4 years ago by
updated 4 years 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, 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...
EyeOnTesting

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

X
Scroll to Top