Captain Tester – Contributor ProfileBy wpengine / December 21, 2024 « Back Captain Tester Questions: No questions found. Answers: Votes Answer 2 votes You actually can accomplish this using LEFT() and RIGHT(), but you will have to nest some of the fun... posted November 5, 2020 10:48 am in reply to Alteryx: How can I add a period into a long string? 2 votes When using the non-in-database join tool in Alteryx, to complete a left join, a right join, or a ful... posted October 21, 2020 4:55 pm in reply to Alteryx: Problems with Joins 2 votes In the past, this could be accomplished by doing a series of pivots and using the filter tool. Howev... posted October 1, 2020 9:41 am in reply to Alteryx: How do I easily remove a record/row that only has null columns???? 2 votes I would accomplish this in one of two ways: Add the outputs into a tool container (or multiple too... posted September 22, 2020 11:40 am in reply to Alteryx: I don't want to keep overwriting an output in a workflow... 3 votes When it comes to Nulls, the Data Cleansing Tool can only do one of two things: Replace with a blank... posted September 2, 2020 2:40 pm in reply to Alteryx: When to use the Imputation Tool instead of Data Cleansing? 2 votes There are several ways to accomplish your goal. I assume in the Formula tool you are using, the outp... posted August 26, 2020 12:46 pm in reply to Alteryx: Changing DateTime to Date via Formula 2 votes Assuming I understand your question correctly, you have a directory with multiple workbooks with dif... posted August 19, 2020 5:46 pm in reply to Alteryx: Directory tool with differently named sheets in a workbook 2 votes This can be accomplished in a few different ways. Option #1: Redefine the field after each 'OR' stat... posted August 5, 2020 5:25 pm in reply to Alteryx: Filter is not working using "OR" statement. 2 votes Absolutely! To add comments within a formula tool you can either add two forward slashes "//" to the... posted July 31, 2020 5:22 pm in reply to Alteryx: Adding comments in the formula tool 2 votes There is a list of all shortcuts in the Alteryx documentation here: https://help.alteryx.com/current... posted July 16, 2020 11:45 am in reply to Alteryx: Hotkey Shortcuts 1 2 Next »