Hello Masters, I have the below data set example where C is the resulting output I need, out of the A & B column i want to select data which has values into C. Please help. ABCR2015-100702015-100702013-10049D2013-10049A2018-002612018-002612018-00113F2018-001132019-00118J2019-00118A2012-100142012-10014

Help with conditional formula / extraction

Hello Masters,

I have the below data set example where C is the resulting output I need, out of the A & B column i want to select data which has values into C.

Please help.

A	B	C
R	2015-10070	2015-10070
2013-10049	D	2013-10049
A	2018-00261	2018-00261
2018-00113	F	2018-00113
2019-00118	J	2019-00118
A	2012-10014	2012-10014

Datasets

Output

Parse

Accepted answers

MarqueeCrew

@AjaySetty ,

Did you happen to try:

MIN([A],[B])

i think that will work. Else Max()

cheers,

mark

All comments

marcusblackhill

Hey @AjaySetty !

Well, depend of the table rules I think, but with data like that you can just concatenate both columns and then remove any letter inside the column like in that example attached.

Hope that help!

Help.yxmd

atcodedog05

Hi @AjaySetty

Here is a workflow for the task.

Formula:

if REGEX_Match([A], "\d+-\d+") then [A]
elseif REGEX_Match([B], "\d+-\d+") then [B]
else Null() endif

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

formula.yxmd

Qiu

@AjaySetty
I am not sure if the Column C is as input or output here.

if output, @atcodedog05 has given great answer.

If input, a filter tool might the one to use.

MarqueeCrew

@AjaySetty ,

Did you happen to try:

MIN([A],[B])

i think that will work. Else Max()

cheers,

mark

grazitti_sapna

Hi @AjaySetty,

Here is my take on this problem.

I hope it helps.

Value.yxmd

atcodedog05

I dont know how exactly does that work, logic behind it.

But interesting concept @MarqueeCrew

Thanks for this great new learning 🙂

AjaySetty

This was so simple and small, now i feel silly to ask this question.

Thanks so much but how does that formula work?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703