journal entry workflow

[meghant03]

I have this column called "journal entry memo" and a check i have to perform is that it can't be longer than 40 characters and if it is I don't have to remove it instead I need to flag it for review so how would I do this in alteryx?

[griffinwelsh]

@meghant03 You can use a filter tool with the length function to check if you string is over 40 characters. From there you can output all problematic rows wherever you need or create a flag column and then union the rows back together for your output. Do you have a specific output format in mind?