Logic

[Zaid]

HI All,

I would request you to help me nail a logic. I have got three fields, x, cond1 and cond 2. the value or metric in x needs to be checked against the condition present in cond1 and cond2 and based on whichever matches correctly, i would need a new column say y, consisting of the condition it satifies, i.e. either cond1 or cond2 or N/A. Please refer to the below mentioned input and desired output file.

Sample Input:

x	cond1	cond2
100	>=99	>=100
100	<=100	<=80
56	>6	>55
100$	>=54$	>=99$
80	>81	>100

Desired output

x	cond1	cond2	y
100	>=99	>=100	cond2
100	<=100	<=80	cond1
56%	>6%	>55%	cond2
100$	>=54$	>=99$	cond2
80	>81	>100	N/A

[LordNeilLord]

Out of interest, I just looked this up as a way to extract decimal numbers....

In the regex tool (in parse mode) you can extract the decimal numbers only by using ([[:digit:].]+)

[MarqueeCrew]

Here's where I was ....

I parsed the data and was ready to start evaluating...  

[Zaid]

hey @LordNeilLord. Unfortunately I am unable to open the last workflow u uploaded, probably because I am using an older version. We just need to change the parsing or any other changes u have done. Can you please send a screenshot of the changes u have done in the regex tool.

Thanks

Zaid

[LordNeilLord]

Hey @Zaid

Here's an 11.7 version for you