SOLVED
Comparing 2 different 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
jerometyl
7 - Meteor
‎08-09-2022
11:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Alteryx Experts
I need some help to compare 2 different columns data. For each row, if the 2 data is the same / if it is one after another, then I will need to check them / to have a remark to check the data.
eg
AB02982 AB02983, I will need to check
AB02982 AB02982, i will need to check
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Datasets
5 REPLIES 5
Qiu
21 - Polaris
‎08-10-2022
12:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jerometyl
We can split the data stream and deal each situation.
‎08-10-2022
12:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Qiu Hi Qiu, thank you for the quick response, but if it is blank, i would also need to go in to validate. Any idea how to change it?
flying008
15 - Aurora
‎08-10-2022
01:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @jerometyl
Please just look that.
iif([ePRNo] = [Right_ePRNo] || ABS(ToNumber(REGEX_Replace([ePRNo], "[A-Z]", '')) - ToNumber(REGEX_Replace([Right_ePRNo], "[A-Z]", ''))) =1, "Check", "-")
If you need check blank, do it with this formula:
iif([ePRNo] = [Right_ePRNo] || IsEmpty([ePRNo]) || IsEmpty([Right_ePRNo]) || ABS(ToNumber(REGEX_Replace([ePRNo], "[A-Z]", '')) - ToNumber(REGEX_Replace([Right_ePRNo], "[A-Z]", ''))) =1, "Check", "-")
‎08-10-2022
01:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you everyone
Qiu
21 - Polaris
‎08-10-2022
01:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@jerometyl
Just a small modification should do it.