Copmaring the format values in two differnt columns

Question

Hello - Can someone please help me to see is there a way we can compare the format of values in two different columns. For example, column A has a value as 0-758-226-112 and column B has a value as 1001887441. I am looking for if the values match the format, get True if not False in column C. I need not to compare whether it is duplicate or not, just the format. Example, 12345 and 67891, this should match the format but 12-345 and 678-91 wont match the format or 12A321 and 123321 wont match the format.

atcodedog05 · Answer

Hi @jkorattiyil

Use this guide to downgrade the packaged workflow

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )

jkorattiyil · Answer

Thank you for your response! However i an not abel to open teh workflow, now sure is it due to any version difference. Can you please type teh formula. Yes, the column A fomrat will always remain same.

JeffK · Answer

Hi @jkorattiyil  - You'll want to write a Formula to REGEX_Match the two columns putting in the pattern from Column A and selecting Column B. I've attached a sample workflow using your first example.

Are these values in Column A always in the same format or varying formats?

Comparing Workflows.yxzp