Conditional formula that effects multiple existing columns
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
himam
6 - Meteoroid
01-19-2023
09:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone,
I am switching over from SAS to Alteryx and was wondering if there is a faster method for what I am trying to do. As per the screen shot, based on the value of column Broker_Name and PTR_LOB_SEG_2 the values of column Segment1, Segment2 & Segment3 would be edited. If I use the formula tool I will have to write this formula 3 times and select Segment1, Segment2 & Segment3. Do you know if there is a faster way of replicating the following ?
Thanks in advance!
Labels:
- Labels:
- Datasets
- Transformation
0 REPLIES 0

