Manish Kumar on

Hi Team,

I am working on an ARIS Query and facing an issue while trying to split a single attribute into two separate columns.

Requirement:
I have an attribute called “Execution type” (maintained at Function level), which contains two values:

  • Automatic
  • Manual

I want to display this in the query result as two separate columns, like:

Execution type Automatic Manual
Automatic 1 0
Manual 0 1

 

What I have tried:

  1. Using Formula in Table View
    • Tried formulas like:
      • IF(C_3 = "Automatic"; 1; 0)
      • IF(C_3 = "Manual"; 1; 0)
    • Also tried different variations:
      • Using comma (,) instead of semicolon (;)
      • Using CONTAINS function
    • Result: Always getting #Error / #Name?
Tags
#queries
Bookmark

 or register to reply.

Notify Moderator