Filter and map column based on last character
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
kauser
8 - Asteroid
‎07-17-2024
12:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
can you please let me know how can i mapping a column based on last character from previous column.
Input
NAME |
DFHR1TA |
DNCH1TB |
RTYD1FG |
WERY1OA |
OUTY1ET |
If last character from input column is between A-B then they should mapped into YES and anything else should be mapped into NO
Output
NAME | TYPE |
DFHR1TA | YES |
DNCH1TB | YES |
RTYD1FG | NO |
WERY1OA | YES |
OUTY1ET | NO |
Labels:
- Labels:
- Developer
- Developer Tools
1 REPLY 1
griffinwelsh
12 - Quasar
‎07-17-2024
12:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can use a formula tool with if,right, and in functions. A screenshot of the required config is attached
