🦉 🎤   RapidMiner Wisdom 2020 - CALL FOR SPEAKERS   🦉 🎤

We are inviting all community members to submit proposals to speak at Wisdom 2020 in Boston.


Whether it's a cool RapidMiner trick or a use case implementation, we want to see what you have.
Form link is below and deadline for submissions is November 15. See you in Boston!

CLICK HERE TO GO TO ENTRY FORM

how I can solved this problem? DataBase error occurred: incorrect column name

alvesddalvesdd Member Posts: 6 Contributor I
edited November 2018 in Help
I read one file.txt and use to generate extratract.

Now a i want write the table in the database.

How i solved this?

Date:
12345     94567
94565     78932

Code:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="5.3.013">
 <context>
   <input/>
   <output/>
   <macros/>
 </context>
 <operator activated="true" class="process" compatibility="5.3.013" expanded="true" name="Process">
   <process expanded="true">
     <operator activated="true" class="read_csv" compatibility="5.3.013" expanded="true" height="60" name="Read CSV" width="90" x="112" y="30">
       <parameter key="csv_file" value="C:\Users\diego_alves\Documents\Rapid\Erro.txt"/>
       <parameter key="first_row_as_names" value="false"/>
       <list key="annotations"/>
       <list key="data_set_meta_data_information">
         <parameter key="0" value="Line.true.nominal.regular"/>
       </list>
     </operator>
     <operator activated="true" class="text:generate_extract" compatibility="5.3.002" expanded="true" height="60" name="Generate Extract" width="90" x="246" y="30">
       <parameter key="source_attribute" value="Line"/>
       <parameter key="query_type" value="Indexed"/>
       <list key="string_machting_queries">
         <parameter key="nome" value="0.5"/>
         <parameter key="outros" value="5.5"/>
         <parameter key="nome2" value="10.5"/>
       </list>
       <list key="regular_expression_queries"/>
       <list key="regular_region_queries"/>
       <list key="xpath_queries"/>
       <list key="namespaces"/>
       <list key="index_queries">
         <parameter key="name" value="0.5"/>
         <parameter key="teste" value="5.5"/>
         <parameter key="outros" value="10.15"/>
       </list>
     </operator>
     <operator activated="true" class="write_database" compatibility="5.3.013" expanded="true" height="60" name="Write Database" width="90" x="380" y="30">
       <parameter key="connection" value="Mailing"/>
       <parameter key="table_name" value="teste3"/>
     </operator>
     <connect from_op="Read CSV" from_port="output" to_op="Generate Extract" to_port="Example Set"/>
     <connect from_op="Generate Extract" from_port="Example Set" to_op="Write Database" to_port="input"/>
     <portSpacing port="source_input 1" spacing="0"/>
     <portSpacing port="sink_result 1" spacing="0"/>
   </process>
 </operator>
</process>

Answers

  • homburghomburg Moderator, Employee, Member Posts: 114  RM Data Scientist
    Hi alvesdd,

    can you please check the output of the "Generate Extract" operator (right click, set a breakpoint after the operator and run the process)? In order to write data to your database system all columns need to have a name that is supported by your dbs.

    Cheers,
    Helge
Sign In or Register to comment.