Operator with conditional value

vhromero
vhromero New Altair Community Member
edited November 2024 in Community Q&A

Hi,

I have an attribute named order_status with 4 possible values: cancelled, pending, processing and processed
and I would like to generate a new attribute named 'label'
with this condition:

if (order_status = 'cancelled' or 'pending')
  value = 'purchased'
THEN
  value = 'not purchased'

Any advice will be appreciate

I am not sure what operator to use and how to implement this condition

Thank you
Tagged:

Answers

  • Andrew2
    Andrew2 New Altair Community Member
    Hello

    Use the 'generate attributes' operator with a suitable if then else. You're very close with your example.

    Regards,

    Andrew
  • vhromero
    vhromero New Altair Community Member
    Hi Andrew,

    Thanks!

    Done with the Operator Generate Attribute: 
    if(matches(order_status, "processing") || matches(order_status, "processed"), "COMPRADO", "NO COMPRADO")

    Now, how can hide/delete the order_status  attribute?

    Thank you
  • swissruss
    swissruss New Altair Community Member
    Hi,

    'Select Attributess' with the single attribute setting, 'order_status' and 'invert selection' ticked should get rid of it.

    Regards,

    Russ

Categories