Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How to get index of particular Example Set?

jaya_darne

Hey Guys,

I am new to Rapid Miner.I am following the below steps for my process :

1. I have a PDF file that I am parsing using ReadPDF option

2.Store the IOO object in the repository.

3.I retieve the IOO object from repository.

4. My tables in PDF get stored as example sets.

5.Using select option i read the Example Set with index 13.

6. Using filter i filter data in that Example set.

I want to provide the index to the Select option dynamically based on a condition. Condition would be select the Example Set having maximum matching attributes.

I am JAVA developer.Please let me know if we can do this using JAVA or any other way.

Please guide me as to how can i go about this.

Your help is greatly appreciated.

Find more posts tagged with

AI Studio

Getting Started

Accepted answers

sgenzer

ok thx @jaya_darne - I just put a bunch of Handle Exceptions in. It's probably not the most elegant solution but it gets the job done.

<?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
    <parameter key="logfile" value="C:\Users\1026445\.RapidMiner\repositories\Local Repository\logs\08_09_2017_logs.log"/>
    <parameter key="resultfile" value="D:\1026445\Project Internal\CISCO- Jaya\Rapid Miner\L1_test.res"/>
    <process expanded="true">
      <operator activated="true" class="pdf_table_extraction:pdf2exampleset_operator" compatibility="0.1.004" expanded="true" height="68" name="Read PDF Table" width="90" x="45" y="34">
        <parameter key="filename" value="/Users/sgenzer/Desktop/Package Qual report R25070FQ.pdf"/>
      </operator>
      <operator activated="true" class="loop_collection" compatibility="7.6.001" expanded="true" height="82" name="Loop Collection" width="90" x="179" y="34">
        <process expanded="true">
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception" width="90" x="45" y="34">
            <process expanded="true">
              <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (3)" width="90" x="45" y="34">
                <parameter key="condition_type" value="attribute_available"/>
                <parameter key="condition_value" value="Test Condition"/>
                <parameter key="expression" value="if(contains([Stress Test],&quot;Convection&quot;),TRUE,FALSE)"/>
                <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>
                <process expanded="true">
                  <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>
                <description align="center" color="transparent" colored="false" width="126">Test Condition exists</description>
              </operator>
              <connect from_port="in 1" to_op="Branch (3)" to_port="condition"/>
              <connect from_op="Branch (3)" from_port="input 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception (2)" width="90" x="179" y="34">
            <process expanded="true">
              <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (4)" width="90" x="112" y="34">
                <parameter key="condition_type" value="attribute_available"/>
                <parameter key="condition_value" value="Stress Test"/>
                <parameter key="expression" value="if(contains(Stress,&quot;Convection&quot;),TRUE,FALSE)"/>
                <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>
                <process expanded="true">
                  <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>
                <description align="center" color="transparent" colored="false" width="126">Stress Test exists</description>
              </operator>
              <connect from_port="in 1" to_op="Branch (4)" to_port="condition"/>
              <connect from_op="Branch (4)" from_port="input 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception (3)" width="90" x="313" y="34">
            <process expanded="true">
              <operator activated="true" class="filter_examples" compatibility="7.6.001" expanded="true" height="103" name="Filter Examples" width="90" x="179" y="34">
                <list key="filters_list">
                  <parameter key="filters_entry_key" value="Stress Test.contains.Convection S"/>
                  <parameter key="filters_entry_key" value="Stress Test.contains.Temperature"/>
                  <parameter key="filters_entry_key" value="Stress Test.contains.High Temperature"/>
                </list>
                <parameter key="filters_logic_and" value="false"/>
                <description align="center" color="transparent" colored="false" width="126">Stress Test contains Convection and Temperature and High Temp</description>
              </operator>
              <connect from_port="in 1" to_op="Filter Examples" to_port="example set input"/>
              <connect from_op="Filter Examples" from_port="example set output" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception (4)" width="90" x="447" y="34">
            <process expanded="true">
              <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (5)" width="90" x="112" y="34">
                <parameter key="condition_type" value="min_examples"/>
                <parameter key="condition_value" value="1"/>
                <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>
                <process expanded="true">
                  <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>
                <description align="center" color="transparent" colored="false" width="126">Number of Examples is &amp;#8805;1</description>
              </operator>
              <connect from_port="in 1" to_op="Branch (5)" to_port="condition"/>
              <connect from_op="Branch (5)" from_port="input 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <connect from_port="single" to_op="Handle Exception" to_port="in 1"/>
          <connect from_op="Handle Exception" from_port="out 1" to_op="Handle Exception (2)" to_port="in 1"/>
          <connect from_op="Handle Exception (2)" from_port="out 1" to_op="Handle Exception (3)" to_port="in 1"/>
          <connect from_op="Handle Exception (3)" from_port="out 1" to_op="Handle Exception (4)" to_port="in 1"/>
          <connect from_op="Handle Exception (4)" from_port="out 1" to_port="output 1"/>
          <portSpacing port="source_single" spacing="0"/>
          <portSpacing port="sink_output 1" spacing="0"/>
          <portSpacing port="sink_output 2" spacing="0"/>
        </process>
      </operator>
      <connect from_op="Read PDF Table" from_port="collection of pdf data tables as example sets" to_op="Loop Collection" to_port="collection"/>
      <connect from_op="Loop Collection" 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>

Scott

All comments

sgenzer

hello @jaya_darne - welcome to the rapidminer user community. We are happy you are here.

I'm not really sure what you mean by "Using select option i read the Example Set with index 13". Can you help me understand a little better what you're trying to do? What would also be helpful is if you paste your RapidMiner XML process in a reply to this thread using the </> feature in the toolbar. Attaching the PDF would also be helpful if possible.

Thanks.

Scott

jaya_darne

<?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
    <parameter key="logverbosity" value="init"/>
    <parameter key="logfile" value="C:\Users\1026445\.RapidMiner\repositories\Local Repository\logs\08_09_2017_logs.log"/>
    <parameter key="resultfile" value="D:\1026445\Project Internal\CISCO- Jaya\Rapid Miner\L1_test.res"/>
    <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="pdf_table_extraction:pdf2exampleset_operator" compatibility="0.1.004" expanded="true" height="68" name="Read PDF Table" width="90" x="45" y="34">
        <parameter key="resource_type" value="file"/>
        <parameter key="filename" value="D:\1026445\Project Internal\CISCO- Jaya\PDF_To_EXcel_L1\LINEAR (2)\LINEAR (2)\LINEAR\LINEAR\MAX11617EEE+\MAX11617EEE+\Package Qual report R25070FQ_MAX11617EEE+.pdf"/>
      </operator>
      <operator activated="true" class="store" compatibility="7.6.001" expanded="true" height="68" name="Store" width="90" x="179" y="34">
        <parameter key="repository_entry" value="//Local Repository/data/L1_data"/>
      </operator>
      <operator activated="true" class="retrieve" compatibility="7.6.001" expanded="true" height="68" name="Retrieve" width="90" x="45" y="238">
        <parameter key="repository_entry" value="//Local Repository/data/L1_data"/>
      </operator>
      <operator activated="true" class="select" compatibility="7.6.001" expanded="true" height="68" name="Select" width="90" x="179" y="238">
        <parameter key="index" value="11"/>
        <parameter key="unfold" value="false"/>
      </operator>
      <operator activated="true" class="retrieve" compatibility="7.6.001" expanded="true" height="68" name="Retrieve (2)" width="90" x="45" y="136">
        <parameter key="repository_entry" value="//Local Repository/data/L1_data"/>
      </operator>
      <operator activated="true" class="select" compatibility="7.6.001" expanded="true" height="68" name="Select (2)" width="90" x="179" y="136">
        <parameter key="index" value="7"/>
        <parameter key="unfold" value="false"/>
      </operator>
      <operator activated="true" class="write_excel" compatibility="7.6.001" expanded="true" height="82" name="Write Excel (3)" width="90" x="313" y="136">
        <parameter key="excel_file" value="C:\Users\1026445\Desktop\L1_1data.xlsx"/>
        <parameter key="file_format" value="xlsx"/>
        <parameter key="encoding" value="SYSTEM"/>
        <parameter key="sheet_name" value="ExampleSet_7"/>
        <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
        <parameter key="number_format" value="#.0"/>
      </operator>
      <operator activated="true" class="write_excel" compatibility="7.6.001" expanded="true" height="82" name="Write Excel (2)" width="90" x="313" y="238">
        <parameter key="excel_file" value="C:\Users\1026445\Desktop\L1_data.xlsx"/>
        <parameter key="file_format" value="xlsx"/>
        <parameter key="encoding" value="SYSTEM"/>
        <parameter key="sheet_name" value="ExampleSet_11"/>
        <parameter key="date_format" value="yyyy-MM-dd HH:mm:ss"/>
        <parameter key="number_format" value="#.0"/>
      </operator>
      <connect from_op="Read PDF Table" from_port="collection of pdf data tables as example sets" to_op="Store" to_port="input"/>
      <connect from_op="Retrieve" from_port="output" to_op="Select" to_port="collection"/>
      <connect from_op="Select" from_port="selected" to_op="Write Excel (2)" to_port="input"/>
      <connect from_op="Retrieve (2)" from_port="output" to_op="Select (2)" to_port="collection"/>
      <connect from_op="Select (2)" from_port="selected" to_op="Write Excel (3)" to_port="input"/>
      <connect from_op="Write Excel (3)" from_port="through" to_port="result 1"/>
      <connect from_op="Write Excel (2)" from_port="through" to_port="result 2"/>
      <portSpacing port="source_input 1" spacing="0"/>
      <portSpacing port="sink_result 1" spacing="0"/>
      <portSpacing port="sink_result 2" spacing="0"/>
      <portSpacing port="sink_result 3" spacing="0"/>
    </process>
  </operator>
</process>

 <operator activated="true" class="select" compatibility="7.6.001" expanded="true" height="68" name="Select (2)" width="90" x="179" y="136">
        <parameter key="index" value="7"/>
In this i want to specify the index based on some conditions.
My PDF file consists of descriptive text as well tables.As seen in the image attached my PDF is converted to 11 Example Sets.Out of this i am selecting Example Set 7 and 11 based on the table i see.Each page is converted to Example Sets in RM. I want to select the example set based on some conditions.

I want to write a solution in JAVA where i would be using this process to read multiple PDF files which are similar in nature. Post reading the PDF i want that the process should pick up the Example Set dynamically based on the attributes in the tables.

RM_ExampleSet.PNG

sgenzer

ah ok @jaya_darne I think I understand. It is hard to test without the PDF but perhaps you can look at this and tweak it for your purposes? The secret here is to use the Loop Collection operator.

<?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
    <parameter key="logfile" value="C:\Users\1026445\.RapidMiner\repositories\Local Repository\logs\08_09_2017_logs.log"/>
    <parameter key="resultfile" value="D:\1026445\Project Internal\CISCO- Jaya\Rapid Miner\L1_test.res"/>
    <process expanded="true">
      <operator activated="true" class="pdf_table_extraction:pdf2exampleset_operator" compatibility="0.1.004" expanded="true" height="68" name="Read PDF Table" width="90" x="45" y="34">
        <parameter key="filename" value="D:\1026445\Project Internal\CISCO- Jaya\PDF_To_EXcel_L1\LINEAR (2)\LINEAR (2)\LINEAR\LINEAR\MAX11617EEE+\MAX11617EEE+\Package Qual report R25070FQ_MAX11617EEE+.pdf"/>
      </operator>
      <operator activated="true" class="loop_collection" compatibility="7.6.001" expanded="true" height="82" name="Loop Collection" width="90" x="179" y="34">
        <process expanded="true">
          <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch" width="90" x="112" y="34">
            <parameter key="condition_type" value="attribute_available"/>
            <parameter key="condition_value" value="Stress Test"/>
            <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>
            <process expanded="true">
              <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="single" to_op="Branch" to_port="condition"/>
          <connect from_op="Branch" from_port="input 1" to_port="output 1"/>
          <portSpacing port="source_single" spacing="0"/>
          <portSpacing port="sink_output 1" spacing="0"/>
          <portSpacing port="sink_output 2" spacing="0"/>
        </process>
      </operator>
      <connect from_op="Read PDF Table" from_port="collection of pdf data tables as example sets" to_op="Loop Collection" to_port="collection"/>
      <connect from_op="Loop Collection" 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>

Scott

jaya_darne

Hey thank you so much..this is a great break through.. can we select more than one attribute values like Stress test and Test condition ? currently we are only using Stress test..

Also can we give a filter on the row values ? Like stress test having row values

Convection Solder Reflow *1

Temperature Cycle *2

High Temperature Storage *2

sgenzer

hmm sure. How is this?

<?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
    <parameter key="logfile" value="C:\Users\1026445\.RapidMiner\repositories\Local Repository\logs\08_09_2017_logs.log"/>
    <parameter key="resultfile" value="D:\1026445\Project Internal\CISCO- Jaya\Rapid Miner\L1_test.res"/>
    <process expanded="true">
      <operator activated="true" class="pdf_table_extraction:pdf2exampleset_operator" compatibility="0.1.004" expanded="true" height="68" name="Read PDF Table" width="90" x="45" y="34">
        <parameter key="filename" value="D:\1026445\Project Internal\CISCO- Jaya\PDF_To_EXcel_L1\LINEAR (2)\LINEAR (2)\LINEAR\LINEAR\MAX11617EEE+\MAX11617EEE+\Package Qual report R25070FQ_MAX11617EEE+.pdf"/>
      </operator>
      <operator activated="true" class="loop_collection" compatibility="7.6.001" expanded="true" height="82" name="Loop Collection" width="90" x="179" y="34">
        <process expanded="true">
          <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (3)" width="90" x="112" y="34">
            <parameter key="condition_type" value="attribute_available"/>
            <parameter key="condition_value" value="Test Condition"/>
            <parameter key="expression" value="if(contains([Stress Test],&quot;Convection&quot;),TRUE,FALSE)"/>
            <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>
            <process expanded="true">
              <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>
            <description align="center" color="transparent" colored="false" width="126">Test Condition exists</description>
          </operator>
          <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (4)" width="90" x="246" y="34">
            <parameter key="condition_type" value="attribute_available"/>
            <parameter key="condition_value" value="Stress Test"/>
            <parameter key="expression" value="if(contains(Stress,&quot;Convection&quot;),TRUE,FALSE)"/>
            <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>
            <process expanded="true">
              <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>
            <description align="center" color="transparent" colored="false" width="126">Stress Test exists</description>
          </operator>
          <operator activated="true" class="filter_examples" compatibility="7.6.001" expanded="true" height="103" name="Filter Examples" width="90" x="380" y="34">
            <list key="filters_list">
              <parameter key="filters_entry_key" value="Stress Test.contains.Convection S"/>
              <parameter key="filters_entry_key" value="Stress Test.contains.Temperature"/>
              <parameter key="filters_entry_key" value="Stress Test.contains.High Temperature"/>
            </list>
            <parameter key="filters_logic_and" value="false"/>
            <description align="center" color="transparent" colored="false" width="126">Stress Test contains Convection and Temperature and High Temp</description>
          </operator>
          <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (5)" width="90" x="514" y="34">
            <parameter key="condition_type" value="min_examples"/>
            <parameter key="condition_value" value="1"/>
            <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>
            <process expanded="true">
              <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>
            <description align="center" color="transparent" colored="false" width="126">Number of Examples is &amp;#8805;1</description>
          </operator>
          <connect from_port="single" to_op="Branch (3)" to_port="condition"/>
          <connect from_op="Branch (3)" from_port="input 1" to_op="Branch (4)" to_port="condition"/>
          <connect from_op="Branch (4)" from_port="input 1" to_op="Filter Examples" to_port="example set input"/>
          <connect from_op="Filter Examples" from_port="example set output" to_op="Branch (5)" to_port="condition"/>
          <connect from_op="Branch (5)" from_port="input 1" to_port="output 1"/>
          <portSpacing port="source_single" spacing="0"/>
          <portSpacing port="sink_output 1" spacing="0"/>
          <portSpacing port="sink_output 2" spacing="0"/>
        </process>
      </operator>
      <connect from_op="Read PDF Table" from_port="collection of pdf data tables as example sets" to_op="Loop Collection" to_port="collection"/>
      <connect from_op="Loop Collection" 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>

Scott

jaya_darne

Hey i am getting an error when i am trying to run yesterday's solution. I had tried the same on my own as well but was getting the same error. I am using RM 7.6.001. Attaching the errors.

RM_error.PNG

Rm_error_post_run.PNG

sgenzer

hello @jaya_darne - ok. Not too surprised. It's not happy because the Filter Examples expects examples even when we send it none. I really cannot test it myself further without the PDF in hand. I need to see how it cycles.

Scott

jaya_darne

Hey attaching the PDF file for your reference.

Package Qual report R25070FQ.pdf

sgenzer

ok thx @jaya_darne - I just put a bunch of Handle Exceptions in. It's probably not the most elegant solution but it gets the job done.

<?xml version="1.0" encoding="UTF-8"?><process version="7.6.001">
  <context>
    <input/>
    <output/>
    <macros/>
  </context>
  <operator activated="true" class="process" compatibility="7.6.001" expanded="true" name="Process">
    <parameter key="logfile" value="C:\Users\1026445\.RapidMiner\repositories\Local Repository\logs\08_09_2017_logs.log"/>
    <parameter key="resultfile" value="D:\1026445\Project Internal\CISCO- Jaya\Rapid Miner\L1_test.res"/>
    <process expanded="true">
      <operator activated="true" class="pdf_table_extraction:pdf2exampleset_operator" compatibility="0.1.004" expanded="true" height="68" name="Read PDF Table" width="90" x="45" y="34">
        <parameter key="filename" value="/Users/sgenzer/Desktop/Package Qual report R25070FQ.pdf"/>
      </operator>
      <operator activated="true" class="loop_collection" compatibility="7.6.001" expanded="true" height="82" name="Loop Collection" width="90" x="179" y="34">
        <process expanded="true">
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception" width="90" x="45" y="34">
            <process expanded="true">
              <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (3)" width="90" x="45" y="34">
                <parameter key="condition_type" value="attribute_available"/>
                <parameter key="condition_value" value="Test Condition"/>
                <parameter key="expression" value="if(contains([Stress Test],&quot;Convection&quot;),TRUE,FALSE)"/>
                <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>
                <process expanded="true">
                  <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>
                <description align="center" color="transparent" colored="false" width="126">Test Condition exists</description>
              </operator>
              <connect from_port="in 1" to_op="Branch (3)" to_port="condition"/>
              <connect from_op="Branch (3)" from_port="input 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception (2)" width="90" x="179" y="34">
            <process expanded="true">
              <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (4)" width="90" x="112" y="34">
                <parameter key="condition_type" value="attribute_available"/>
                <parameter key="condition_value" value="Stress Test"/>
                <parameter key="expression" value="if(contains(Stress,&quot;Convection&quot;),TRUE,FALSE)"/>
                <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>
                <process expanded="true">
                  <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>
                <description align="center" color="transparent" colored="false" width="126">Stress Test exists</description>
              </operator>
              <connect from_port="in 1" to_op="Branch (4)" to_port="condition"/>
              <connect from_op="Branch (4)" from_port="input 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception (3)" width="90" x="313" y="34">
            <process expanded="true">
              <operator activated="true" class="filter_examples" compatibility="7.6.001" expanded="true" height="103" name="Filter Examples" width="90" x="179" y="34">
                <list key="filters_list">
                  <parameter key="filters_entry_key" value="Stress Test.contains.Convection S"/>
                  <parameter key="filters_entry_key" value="Stress Test.contains.Temperature"/>
                  <parameter key="filters_entry_key" value="Stress Test.contains.High Temperature"/>
                </list>
                <parameter key="filters_logic_and" value="false"/>
                <description align="center" color="transparent" colored="false" width="126">Stress Test contains Convection and Temperature and High Temp</description>
              </operator>
              <connect from_port="in 1" to_op="Filter Examples" to_port="example set input"/>
              <connect from_op="Filter Examples" from_port="example set output" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <operator activated="true" class="handle_exception" compatibility="7.6.001" expanded="true" height="82" name="Handle Exception (4)" width="90" x="447" y="34">
            <process expanded="true">
              <operator activated="true" class="branch" compatibility="7.6.001" expanded="true" height="82" name="Branch (5)" width="90" x="112" y="34">
                <parameter key="condition_type" value="min_examples"/>
                <parameter key="condition_value" value="1"/>
                <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>
                <process expanded="true">
                  <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>
                <description align="center" color="transparent" colored="false" width="126">Number of Examples is &amp;#8805;1</description>
              </operator>
              <connect from_port="in 1" to_op="Branch (5)" to_port="condition"/>
              <connect from_op="Branch (5)" from_port="input 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
            <process expanded="true">
              <connect from_port="in 1" to_port="out 1"/>
              <portSpacing port="source_in 1" spacing="0"/>
              <portSpacing port="source_in 2" spacing="0"/>
              <portSpacing port="sink_out 1" spacing="0"/>
              <portSpacing port="sink_out 2" spacing="0"/>
            </process>
          </operator>
          <connect from_port="single" to_op="Handle Exception" to_port="in 1"/>
          <connect from_op="Handle Exception" from_port="out 1" to_op="Handle Exception (2)" to_port="in 1"/>
          <connect from_op="Handle Exception (2)" from_port="out 1" to_op="Handle Exception (3)" to_port="in 1"/>
          <connect from_op="Handle Exception (3)" from_port="out 1" to_op="Handle Exception (4)" to_port="in 1"/>
          <connect from_op="Handle Exception (4)" from_port="out 1" to_port="output 1"/>
          <portSpacing port="source_single" spacing="0"/>
          <portSpacing port="sink_output 1" spacing="0"/>
          <portSpacing port="sink_output 2" spacing="0"/>
        </process>
      </operator>
      <connect from_op="Read PDF Table" from_port="collection of pdf data tables as example sets" to_op="Loop Collection" to_port="collection"/>
      <connect from_op="Loop Collection" 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>

Scott

jaya_darne

Hey thank you so much for the solution..!!

If i need to use this IOO object in java for further processing,how do i access the object?

I am aware that we have a RM jar and the process function is used to run the process we define.

sgenzer

hello @jaya_darne - glad it worked for you. Don't know the answer to your Java question. Hope someone else can chime in.

Scott

jaya_darne

Suppose i want to extract two tables from the PDF. One is on pg 2 and the other table on pg 3. Giving similar process as we did before. How can we achieve this?