Data Foundry Expressions

<EXPRESSION LABEL="" NAME="IF" TYPE="VOID" URL="">
  <COMMENT>Category_Name이 'Mobile'이면 SubCategory를 'SubMobile'로 값을 채우기</COMMENT>
 
  <EXPRESSION LABEL="" NAME="MATH" TYPE="INTEGER" URL="">
    <EXPRNODE NAME="TYPE" VALUE="STRING"/>
    <EXPRNODE NAME="OPERATOR" VALUE="EQUAL"/>
    <EXPRESSION LABEL="" NAME="IDENTITY" TYPE="PROPERTY" URL="">
      <EXPRNODE NAME="PROP_NAME" VALUE="Category_Name"/>
    </EXPRESSION>
    <EXPRESSION LABEL="" NAME="CONST" TYPE="STRING" URL="">
      <EXPRNODE NAME="VALUE" VALUE="Mobile"/>
    </EXPRESSION>
  </EXPRESSION>

  <EXPRESSION LABEL="" NAME="CREATE" TYPE="VOID" URL="">
    <EXPRNODE NAME="PROP_NAME" VALUE="SubCategory"/>
    <EXPRESSION LABEL="" NAME="CONST" TYPE="STRING" URL="">
      <EXPRNODE NAME="VALUE" VALUE="SubMobile"/>
    </EXPRESSION>
  </EXPRESSION>

</EXPRESSION>

/*----------------------------------------------------------------------------*/
<EXPRESSION LABEL="" NAME="IF" TYPE="VOID" URL="">
  <COMMENT>SubCategory가 'null'이면 'SubMobile'로 채우기</COMMENT>
 
  <EXPRESSION LABEL="" NAME="MATH" TYPE="INTEGER" URL="">
    <EXPRNODE NAME="TYPE" VALUE="INTEGER"/>
    <EXPRNODE NAME="OPERATOR" VALUE="EQUAL"/>
    <EXPRESSION LABEL="" NAME="PROP_EXISTS" TYPE="INTEGER" URL="">
      <EXPRNODE NAME="PROP_NAME" VALUE="SubCategory"/>
    </EXPRESSION>
    <EXPRESSION LABEL="" NAME="CONST" TYPE="INTEGER" URL="">
      <EXPRNODE NAME="VALUE" VALUE="0"/>
    </EXPRESSION>
  </EXPRESSION>

  <EXPRESSION LABEL="" NAME="CREATE" TYPE="VOID" URL="">
    <EXPRNODE NAME="PROP_NAME" VALUE="SubCategory"/>
    <EXPRESSION LABEL="" NAME="CONST" TYPE="STRING" URL="">
      <EXPRNODE NAME="VALUE" VALUE="SubMobile"/>
    </EXPRESSION>
  </EXPRESSION>

</EXPRESSION>

/*----------------------------------------------------------------------------*/
<EXPRESSION LABEL="" NAME="UPDATE" TYPE="VOID" URL="">
  <COMMENT>DISCONTINUED의 'Discontinued'를 'Yes'로 replace</COMMENT>
 
  <EXPRNODE NAME="PROP_NAME" VALUE="DISCONTINUED"/>

  <EXPRESSION LABEL="" NAME="REPLACE" TYPE="STRING" URL="">
    <EXPRNODE NAME="TARGET" VALUE="Discontinued"/>
    <EXPRNODE NAME="REPLACEMENT" VALUE="Yes"/>
    <EXPRESSION LABEL="" NAME="IDENTITY" TYPE="PROPERTY" URL="">
      <EXPRNODE NAME="PROP_NAME" VALUE="DISCONTINUED"/>
    </EXPRESSION>
  </EXPRESSION>

</EXPRESSION>