journal entry workflow
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Optimization
- Topic of Interest
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You would use the LENGTH formula
If LENGTH([Journal entry memo]) > 40
Then "Research"
Else "Okay"
Endif
Something like that and then you can Filter for "Research"
Or add a Filter for LENGTH([Journal entry memo]) > 40
If this works for you, please mark the post as Solved!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use something like the following in a formula tool.
if Length([Field1]) <= 40 then 'OK' else 'Check' endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
if i do this then the value will be replaced by "Research", I still need the value to be there but it should be flagged for review. For example, if the journal entry memo value is "feb payroll.10000" i still need that value to show after i apply the formula and not be replaced by "Research"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the Formula tool, don't select an existing field. Choose the option for Add Column.
If you are unfamiliar with the basic functionality of the Formula tool, at the top of this page check out
Learn > Academy > Learning Paths
Learn > Academy > Interactive Lessons
 
