Comparing 2 different columns

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.

AB02982 AB02983, I will need to check

AB02982 AB02982, i will need to check

ePR number check.xlsx

Datasets

Common Use Cases

Accepted answers

flying008

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", "-")

录制_2022_08_10_16_01_54_140.gif

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", "-")

Qiu

@jerometyl
Just a small modification should do it.

0810-jerometyl - r1.yxmd

All comments

Qiu

@jerometyl
We can split the data stream and deal each situation.

0810-jerometyl.yxmd

jerometyl

@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

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", "-")

录制_2022_08_10_16_01_54_140.gif

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", "-")

jerometyl

Thank you everyone

Qiu

@jerometyl
Just a small modification should do it.

0810-jerometyl - r1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703