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?

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

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

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

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