Votes
Answers
Views
Question
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...
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
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?
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
411
views
asked 3 years ago by
updated 3 years ago by
Category: Data Analytics
I have a basic workflow and I am working on testing the data. There are roughly ten different .yxdb outputs, and I don't want to continue overwriting them while testing. I have been copying and pasting my workflow in a new yxmd file then deleting the outputs in this second workflow for testing. Is t...
5
votes
1
answer
300
views
asked 3 years ago by
updated 3 years ago by
Category: Data Analytics
I have always just used the Data Cleansing tool to fill in null values with zeroes. I have never really used the imputation tool and am not sure when or why it would be used, and what advantages it present. Could someone point out some use cases and functionality of the imputation tool that merits i...
4
votes
1
answer
610
views
asked 3 years ago by
updated 3 years ago by
Category: Data Analytics
I am trying to change a field in the format 'yyyy-mm-dd hh:mm:ss' from a DateTime datatype to a Date datatype 'yyy-mm-dd'. I am accomplishing this in the Formula tool with Left([DateTimeField], 10) but I am unable to change the data type in the formula tool and the output still has the full DateTime...
4
votes
1
answer
196
views
asked 3 years ago by
updated 3 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.
4
votes
1
answer
641
views
asked 3 years ago by
updated 3 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?
EyeOnTesting

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

X
Scroll to Top