How to create new Rows data based on split character values in Column data

Vanlal
Vanlal New Altair Community Member
edited November 2024 in Community Q&A
I have data like as below
  
Name Subject Grade
John Eng,Math A,B
Clarice Eng,Science O,B
Kennedy Math O
Kevin Eng A

How do i generate new rows based on the column which has , on them

Name Subject Grade
John Eng A
John Math B
Clarice Eng O
Clarice Science B
Kennedy Math O
Kevin Eng A

Best Answer

Answers

  • Vanlal
    Vanlal New Altair Community Member
    <div><?xml version="1.0" encoding="UTF-8"?><process version="9.6.000"></div><div>&nbsp; <context></div><div>&nbsp; &nbsp; <input/></div><div>&nbsp; &nbsp; <output/></div><div>&nbsp; &nbsp; <macros/></div><div>&nbsp; </context></div><div>&nbsp; <operator activated="true" class="process" compatibility="9.6.000" expanded="true" name="Process"></div><div>&nbsp; &nbsp; <parameter key="logverbosity" value="init"/></div><div>&nbsp; &nbsp; <parameter key="random_seed" value="2001"/></div><div>&nbsp; &nbsp; <parameter key="send_mail" value="never"/></div><div>&nbsp; &nbsp; <parameter key="notification_email" value=""/></div><div>&nbsp; &nbsp; <parameter key="process_duration_for_mail" value="30"/></div><div>&nbsp; &nbsp; <parameter key="encoding" value="SYSTEM"/></div><div>&nbsp; &nbsp; <process expanded="true"></div><div>&nbsp; &nbsp; &nbsp; <operator activated="true" class="retrieve" compatibility="9.6.000" expanded="true" height="68" name="Retrieve resulttest" width="90" x="45" y="34"></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="repository_entry" value="//Local Repository/data/resulttest"/></div><div>&nbsp; &nbsp; &nbsp; </operator></div><div>&nbsp; &nbsp; &nbsp; <operator activated="true" class="split" compatibility="9.6.000" expanded="true" height="82" name="Split" width="90" x="179" y="34"></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="attribute_filter_type" value="all"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="attribute" value=""/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="attributes" value=""/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="use_except_expression" value="false"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="value_type" value="nominal"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="use_value_type_exception" value="false"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="except_value_type" value="file_path"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="block_type" value="single_value"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="use_block_type_exception" value="false"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="except_block_type" value="single_value"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="invert_selection" value="false"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="include_special_attributes" value="false"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="split_pattern" value=","/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="split_mode" value="ordered_split"/></div><div>&nbsp; &nbsp; &nbsp; </operator></div><div>&nbsp; &nbsp; &nbsp; <operator activated="true" class="de_pivot" compatibility="9.6.000" expanded="true" height="82" name="De-Pivot" width="90" x="313" y="34"></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <list key="attribute_name"></div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <parameter key="Subject" value="Subject.*"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <parameter key="Grade" value="Grade.*"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; </list></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="index_attribute" value="id"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="create_nominal_index" value="false"/></div><div>&nbsp; &nbsp; &nbsp; &nbsp; <parameter key="keep_missings" value="false"/></div><div>&nbsp; &nbsp; &nbsp; </operator></div><div>&nbsp; &nbsp; &nbsp; <connect from_op="Retrieve resulttest" from_port="output" to_op="Split" to_port="example set input"/></div><div>&nbsp; &nbsp; &nbsp; <connect from_op="Split" from_port="example set output" to_op="De-Pivot" to_port="example set input"/></div><div>&nbsp; &nbsp; &nbsp; <connect from_op="De-Pivot" from_port="example set output" to_port="result 1"/></div><div>&nbsp; &nbsp; &nbsp; <portSpacing port="source_input 1" spacing="0"/></div><div>&nbsp; &nbsp; &nbsp; <portSpacing port="sink_result 1" spacing="0"/></div><div>&nbsp; &nbsp; &nbsp; <portSpacing port="sink_result 2" spacing="0"/></div><div>&nbsp; &nbsp; </process></div><div>&nbsp; </operator></div><div></process></div>

    It is working now .. Thank you

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.