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

VanlalVanlal Member Posts: 12 Contributor II
edited September 2020 in Help
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

  • VanlalVanlal Member Posts: 12 Contributor II
    <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
Sign In or Register to comment.