select attribute and save
Hello to everyone,
I want to save in differents txt files some comments which are in an excel file. I use the operator "read excel" , "select attribute" , "write as a text" .
My code is:
Thanks!!!
I want to save in differents txt files some comments which are in an excel file. I use the operator "read excel" , "select attribute" , "write as a text" .
My code is:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>As a result i take one txt file with all the comments.What i must to do to save the comments in differents files?
<process version="5.1.008">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="5.1.008" expanded="true" name="Process">
<parameter key="encoding" value="UTF-8"/>
<parameter key="parallelize_main_process" value="true"/>
<process expanded="true" height="280" width="547">
<operator activated="true" class="read_excel" compatibility="5.1.008" expanded="true" height="60" name="Read Excel" width="90" x="65" y="66">
<parameter key="excel_file" value="C:\Users\elenious\Desktop\diplomatiki\newresults\ypes_comments_98.xls"/>
<parameter key="imported_cell_range" value="G1:G1362"/>
<parameter key="first_row_as_names" value="false"/>
<list key="annotations">
<parameter key="0" value="Name"/>
</list>
<list key="data_set_meta_data_information">
<parameter key="0" value="Σχόλιο.true.polynominal.attribute"/>
</list>
</operator>
<operator activated="true" class="select_attributes" compatibility="5.1.008" expanded="true" height="76" name="Select Attributes" width="90" x="246" y="75">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="Σχόλιο"/>
<parameter key="attributes" value="|Σχόλιο"/>
<parameter key="value_type" value="text"/>
<parameter key="include_special_attributes" value="true"/>
</operator>
<operator activated="true" class="write_as_text" compatibility="5.1.008" expanded="true" height="76" name="Write as Text" width="90" x="447" y="210">
<parameter key="result_file" value="C:\Users\elenious\Desktop\asbeo comte\comments_%{a}.txt"/>
<parameter key="encoding" value="UTF-8"/>
</operator>
<connect from_op="Read Excel" from_port="output" to_op="Select Attributes" to_port="example set input"/>
<connect from_op="Select Attributes" from_port="example set output" to_op="Write as Text" to_port="input 1"/>
<connect from_op="Write as Text" from_port="input 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>
Thanks!!!