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 |
Solved! Go to Solution.
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:].]+)
Here's where I was ....
I parsed the data and was ready to start evaluating...
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