Data Appearing as Rows Instead of Attributes (Columns)

blake_galbreath
blake_galbreath New Altair Community Member
edited November 2024 in Community Q&A

Hello,

 

I am trying to get 2 entities from a website using Xpath:

//h:h2[(@class='uvIdeaTitle')]/h:a/text()

//h:div[(@class='uvIdeaVoteCount')]/h:strong/text()

 

I get all of the correct data, but they appear as sequential rows, instead of separate columns under the Results tab.

 

I am using the following process:

Read Excel > Get Pages > Data to Documents > Process Documents (Cut Document).

 

How can I retrieve the data in the following structure:

URL -- Idea Title -- Vote Count

instead of 

URL -- Idea Title

URL -- Vote Count

 

Thanks,

Blake

 

 

Tagged:

Best Answer

  • YYH
    YYH
    Altair Employee
    Answer ✓

    Hi @blake_galbreath 

     

    You will need pivot operator. 

     

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.001">
    <context>
    <input/>
    <output/>
    <macros/>
    </context>
    <operator activated="true" class="process" compatibility="8.1.001" expanded="true" name="Process">
    <parameter key="process_duration_for_mail" value="1"/>
    <parameter key="encoding" value="UTF-8"/>
    <process expanded="true">
    <operator activated="true" class="generate_data_user_specification" compatibility="8.1.001" expanded="true" height="68" name="Generate Data by User Specification" width="90" x="313" y="34">
    <list key="attribute_values">
    <parameter key="URL" value="&quot;rapidminer.com&quot;"/>
    <parameter key="value" value="&quot;marketing&quot;"/>
    <parameter key="att_name" value="&quot;idea_tittle&quot;"/>
    </list>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="generate_data_user_specification" compatibility="8.1.001" expanded="true" height="68" name="Generate Data by User Specification (2)" width="90" x="313" y="136">
    <list key="attribute_values">
    <parameter key="URL" value="&quot;rapidminer.com&quot;"/>
    <parameter key="value" value="&quot;4&quot;"/>
    <parameter key="att_name" value="&quot;vote_count&quot;"/>
    </list>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="append" compatibility="8.1.001" expanded="true" height="103" name="Append" width="90" x="447" y="34"/>
    <operator activated="true" breakpoints="before" class="pivot" compatibility="8.1.001" expanded="true" height="82" name="Pivot" width="90" x="581" y="34">
    <parameter key="group_attribute" value="URL"/>
    <parameter key="index_attribute" value="att_name"/>
    <parameter key="consider_weights" value="false"/>
    </operator>
    <connect from_op="Generate Data by User Specification" from_port="output" to_op="Append" to_port="example set 1"/>
    <connect from_op="Generate Data by User Specification (2)" from_port="output" to_op="Append" to_port="example set 2"/>
    <connect from_op="Append" from_port="merged set" to_op="Pivot" to_port="example set input"/>
    <connect from_op="Pivot" from_port="example set output" 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>

     Cheers,

    YY

Answers

  • YYH
    YYH
    Altair Employee
    Answer ✓

    Hi @blake_galbreath 

     

    You will need pivot operator. 

     

    <?xml version="1.0" encoding="UTF-8"?><process version="8.1.001">
    <context>
    <input/>
    <output/>
    <macros/>
    </context>
    <operator activated="true" class="process" compatibility="8.1.001" expanded="true" name="Process">
    <parameter key="process_duration_for_mail" value="1"/>
    <parameter key="encoding" value="UTF-8"/>
    <process expanded="true">
    <operator activated="true" class="generate_data_user_specification" compatibility="8.1.001" expanded="true" height="68" name="Generate Data by User Specification" width="90" x="313" y="34">
    <list key="attribute_values">
    <parameter key="URL" value="&quot;rapidminer.com&quot;"/>
    <parameter key="value" value="&quot;marketing&quot;"/>
    <parameter key="att_name" value="&quot;idea_tittle&quot;"/>
    </list>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="generate_data_user_specification" compatibility="8.1.001" expanded="true" height="68" name="Generate Data by User Specification (2)" width="90" x="313" y="136">
    <list key="attribute_values">
    <parameter key="URL" value="&quot;rapidminer.com&quot;"/>
    <parameter key="value" value="&quot;4&quot;"/>
    <parameter key="att_name" value="&quot;vote_count&quot;"/>
    </list>
    <list key="set_additional_roles"/>
    </operator>
    <operator activated="true" class="append" compatibility="8.1.001" expanded="true" height="103" name="Append" width="90" x="447" y="34"/>
    <operator activated="true" breakpoints="before" class="pivot" compatibility="8.1.001" expanded="true" height="82" name="Pivot" width="90" x="581" y="34">
    <parameter key="group_attribute" value="URL"/>
    <parameter key="index_attribute" value="att_name"/>
    <parameter key="consider_weights" value="false"/>
    </operator>
    <connect from_op="Generate Data by User Specification" from_port="output" to_op="Append" to_port="example set 1"/>
    <connect from_op="Generate Data by User Specification (2)" from_port="output" to_op="Append" to_port="example set 2"/>
    <connect from_op="Append" from_port="merged set" to_op="Pivot" to_port="example set input"/>
    <connect from_op="Pivot" from_port="example set output" 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>

     Cheers,

    YY

  • blake_galbreath
    blake_galbreath New Altair Community Member
    Thank you!
    Blake

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.