What is wrong in this process? Why "Encartera" is not recognized?

cdaponte

Hi, i leave here the process. Thanks in advanced! 

<?xml version="1.0" encoding="UTF-8"?><process version="9.3.000">

  <context>

    <input/>

    <output/>

    <macros/>

  </context>

  <operator activated="true" class="process" compatibility="9.3.000" expanded="true" name="Process">

    <parameter key="logverbosity" value="init"/>

    <parameter key="random_seed" value="2001"/>

    <parameter key="send_mail" value="never"/>

    <parameter key="notification_email" value=""/>

    <parameter key="process_duration_for_mail" value="30"/>

    <parameter key="encoding" value="SYSTEM"/>

    <process expanded="true">

      <operator activated="true" class="retrieve" compatibility="9.3.000" expanded="true" height="68" name="Retrieve 01-DB-Banco Galicia" width="90" x="45" y="85">

        <parameter key="repository_entry" value="//Local Repository/processes/Banco Galicia/01-DB-Banco Galicia"/>

      </operator>

      <operator activated="true" class="select_attributes" compatibility="9.3.000" expanded="true" height="82" name="Select Attributes (2)" width="90" x="179" y="85">

        <parameter key="attribute_filter_type" value="subset"/>

        <parameter key="attribute" value=""/>

        <parameter key="attributes" value="CART_ESCENARIO|clasif_bcra|dias_mora|documento|edad|Encartera|fecha|idig_cqrech|idig_deudbcra|idig_inmuebles|idig_sociedades|idig_vehiculos|laboral|N_PRODUCTOS|p_busq_idig|pago_mes|pago_mes_anterior|pago_vtas|prov_domicilio|SALDO_AJUSTADO_TOTAL|sexo|sucursal|u_busq_idig"/>

        <parameter key="use_except_expression" value="false"/>

        <parameter key="value_type" value="attribute_value"/>

        <parameter key="use_value_type_exception" value="false"/>

        <parameter key="except_value_type" value="time"/>

        <parameter key="block_type" value="attribute_block"/>

        <parameter key="use_block_type_exception" value="false"/>

        <parameter key="except_block_type" value="value_matrix_row_start"/>

        <parameter key="invert_selection" value="false"/>

        <parameter key="include_special_attributes" value="false"/>

      </operator>

      <operator activated="true" class="filter_examples" compatibility="9.3.000" expanded="true" height="103" name="Filter Examples (2)" width="90" x="313" y="85">

        <parameter key="parameter_expression" value=""/>

        <parameter key="condition_class" value="custom_filters"/>

        <parameter key="invert_filter" value="false"/>

        <list key="filters_list">

          <parameter key="filters_entry_key" value="sexo.is_not_missing."/>

          <parameter key="filters_entry_key" value="clasif_bcra.is_not_missing."/>

          <parameter key="filters_entry_key" value="dias_mora.is_not_missing."/>

          <parameter key="filters_entry_key" value="prov_domicilio.is_in.BUENOS AIRES;CAPITAL FEDERAL;CATAMARCA;CHACO;CHUBUT;CORDOBA;CORRIENTES;ENTRE RIOS;FORMOSA;JUJUY;LA PAMPA;LA RIOJA;MENDOZA;MISIONES;NEUQUEN;RIO NEGRO;SALTA;SAN JUAN;SAN LUIS;SANTA CRUZ;SANTA FE;SANTIAGO DEL ESTERO;TIERRA DEL FUEGO;TUCUMAN"/>

          <parameter key="filters_entry_key" value="p_busq_idig.is_not_missing."/>

          <parameter key="filters_entry_key" value="CART_ESCENARIO.is_not_missing."/>

        </list>

        <parameter key="filters_logic_and" value="true"/>

        <parameter key="filters_check_metadata" value="true"/>

      </operator>

      <operator activated="true" class="set_macro" compatibility="9.3.000" expanded="true" height="82" name="Set Macro" width="90" x="447" y="85">

        <parameter key="macro" value="kiwi"/>

        <parameter key="value" value="ASIGNADO"/>

      </operator>

      <operator activated="true" class="concurrency:loop_values" compatibility="9.3.000" expanded="true" height="82" name="Loop Values" width="90" x="581" y="85">

        <parameter key="attribute" value="Encartera"/>

        <parameter key="iteration_macro" value="%{kiwi}"/>

        <parameter key="reuse_results" value="false"/>

        <parameter key="enable_parallel_execution" value="true"/>

        <process expanded="true">

          <operator activated="true" class="branch" compatibility="9.3.000" expanded="true" height="82" name="Branch" width="90" x="179" y="34">

            <parameter key="condition_type" value="expression"/>

            <parameter key="expression" value="if(equals(Encartera,&quot;ASIGNADO&quot;),TRUE,FALSE)"/>

            <parameter key="io_object" value="ANOVAMatrix"/>

            <parameter key="return_inner_output" value="false"/>

            <process expanded="true">

              <operator activated="true" class="filter_examples" compatibility="9.3.000" expanded="true" height="103" name="Filter Examples" width="90" x="45" y="34">

                <parameter key="parameter_expression" value=""/>

                <parameter key="condition_class" value="custom_filters"/>

                <parameter key="invert_filter" value="false"/>

                <list key="filters_list">

                  <parameter key="filters_entry_key" value="pago_mes.le.0\.0"/>

                  <parameter key="filters_entry_key" value="pago_mes_anterior.le.0\.0"/>

                </list>

                <parameter key="filters_logic_and" value="true"/>

                <parameter key="filters_check_metadata" value="true"/>

              </operator>

              <operator activated="true" class="select_attributes" compatibility="9.3.000" expanded="true" height="82" name="Select Attributes" width="90" x="179" y="34">

                <parameter key="attribute_filter_type" value="subset"/>

                <parameter key="attribute" value=""/>

                <parameter key="attributes" value="Encartera|pago_mes|pago_mes_anterior|pago_vtas"/>

                <parameter key="use_except_expression" value="false"/>

                <parameter key="value_type" value="attribute_value"/>

                <parameter key="use_value_type_exception" value="false"/>

                <parameter key="except_value_type" value="time"/>

                <parameter key="block_type" value="attribute_block"/>

                <parameter key="use_block_type_exception" value="false"/>

                <parameter key="except_block_type" value="value_matrix_row_start"/>

                <parameter key="invert_selection" value="false"/>

                <parameter key="include_special_attributes" value="false"/>

              </operator>

              <operator activated="true" class="order_attributes" compatibility="9.3.000" expanded="true" height="82" name="Reorder Attributes" width="90" x="313" y="34">

                <parameter key="sort_mode" value="user specified"/>

                <parameter key="attribute_ordering" value="Encartera|pago_mes|pago_mes_anterior|pago_vtas|CART_ESCENARIO|clasif_bcra|dias_mora|documento|edad|fecha|idig_cqrech|idig_deudbcra|idig_inmuebles|idig_sociedades|idig_vehiculos|laboral|N_PRODUCTOS|p_busq_idig|prov_domicilio|SALDO_AJUSTADO_TOTAL|sexo|sucursal|u_busq_idig"/>

                <parameter key="use_regular_expressions" value="false"/>

                <parameter key="handle_unmatched" value="append"/>

                <parameter key="sort_direction" value="ascending"/>

              </operator>

              <connect from_port="condition" to_op="Filter Examples" to_port="example set input"/>

              <connect from_op="Filter Examples" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>

              <connect from_op="Select Attributes" from_port="example set output" to_op="Reorder Attributes" to_port="example set input"/>

              <connect from_op="Reorder Attributes" from_port="example set output" to_port="input 1"/>

              <portSpacing port="source_condition" spacing="0"/>

              <portSpacing port="source_input 1" spacing="0"/>

              <portSpacing port="sink_input 1" spacing="0"/>

              <portSpacing port="sink_input 2" spacing="0"/>

            </process>

            <process expanded="true">

              <connect from_port="condition" to_port="input 1"/>

              <portSpacing port="source_condition" spacing="0"/>

              <portSpacing port="source_input 1" spacing="0"/>

              <portSpacing port="sink_input 1" spacing="0"/>

              <portSpacing port="sink_input 2" spacing="0"/>

            </process>

          </operator>

          <connect from_port="input 1" to_op="Branch" to_port="condition"/>

          <connect from_op="Branch" from_port="input 1" to_port="output 1"/>

          <portSpacing port="source_input 1" spacing="0"/>

          <portSpacing port="source_input 2" spacing="0"/>

          <portSpacing port="sink_output 1" spacing="0"/>

          <portSpacing port="sink_output 2" spacing="0"/>

        </process>

      </operator>

      <connect from_op="Retrieve 01-DB-Banco Galicia" from_port="output" to_op="Select Attributes (2)" to_port="example set input"/>

      <connect from_op="Select Attributes (2)" from_port="example set output" to_op="Filter Examples (2)" to_port="example set input"/>

      <connect from_op="Filter Examples (2)" from_port="example set output" to_op="Set Macro" to_port="through 1"/>

      <connect from_op="Set Macro" from_port="through 1" to_op="Loop Values" to_port="input 1"/>

      <connect from_op="Loop Values" from_port="output 1" to_port="result 1"/>

      <portSpacing port="source_input 1" spacing="0"/>

      <portSpacing port="sink_result 1" spacing="0"/>

      <portSpacing port="sink_result 2" spacing="0"/>

    </process>

  </operator>

</process>

sgenzer

hi @cdaponte I could not reproduce your process with that XML as I do not have the data set "Retrieve 01-DB-Banco Galicia". Nevertheless I think I understand the problem. Basically your expression is trying to compare an entire attribute with a value which is not possible. Perhaps you want to do this instead?

if(%{kiwi}=="ASIGNADO",TRUE,FALSE)

Scott