Comparing 2 different columns

[jerometyl]

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 

[Qiu]

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

[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 · Accepted solution]

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

[jerometyl]

Thank you everyone

[Qiu · Accepted solution]

@jerometyl 
Just a small modification should do it.