Forum Discussion

kosa_seba's avatar
kosa_seba
New Member
3 years ago
Solved

Comparison sing inside dataset

Hello, I am searching for help with this unique example. 

I have in my dataset column with comparison sign.

Is it possible to compare Value and use sing from the column? I want to create one column with a flag if Value is in the specification

In the first example, 0 is in spec because it is below 20

In the second example, 1 is not equal to 0 and it is not

I really appreciate any help you can provide.

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

    Hi kosa_seba ,

     

    You would have to do this using a conditional column that defines what the text representation of the operator (Sign) means, and apply it to an appropriate calculation.

    For example, your conditional column would have to be built something like this:

    if [Sign] = "<" and [Value] < [SingValue] then "In Spec"
else if [Sign] = ">" and [Value] > [SingValue] then "In Spec"
else if [Sign] = "=" and [Value] = [SingValue] then "In Spec"
...
...
else  // your escape value e.g. "Not In Spec", null etc.

     

    Pete

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi kosa_seba ,

     

    You would have to do this using a conditional column that defines what the text representation of the operator (Sign) means, and apply it to an appropriate calculation.

    For example, your conditional column would have to be built something like this:

    if [Sign] = "<" and [Value] < [SingValue] then "In Spec"
else if [Sign] = ">" and [Value] > [SingValue] then "In Spec"
else if [Sign] = "=" and [Value] = [SingValue] then "In Spec"
...
...
else  // your escape value e.g. "Not In Spec", null etc.

     

    Pete