Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

custom Filter Formula


I am wondering which custom Filter Formula I will need to use to say move everything that applies to that filter down one row. So for example column a is all numbers except half way through there is words - so when it sees the words I want the data to move down one row and a space to appear between the data ? Is this possible. Example how I want it to look below:


101                                                 101

102                   to look like this      102

103                                                 103


104                                                 ASD

105                                                 104


Alteryx Certified Partner
Alteryx Certified Partner

I've attached an example of how this can be done. This workflow identifies string values, and duplicates those records so they can be unioned back into the original data with empty values. The position is controlled by modifying a RecordID field.