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...

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?

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!

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.

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?

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...

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...

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...

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.