New guy - learning how to clean up and parse a CSV file
Find more posts tagged with
Sort by:
1 - 4 of
41
Sort by:
1 - 1 of
11
Altair Employeehi @WesCo2019 - you're going to want to first put it into a date-time data type:
As for parsing, I would use "Generate Attributes" to create separate attributes for each piece you want:
Hope that helps.
Scott
As for parsing, I would use "Generate Attributes" to create separate attributes for each piece you want:
<?xml version="1.0" encoding="UTF-8"?><process version="9.0.003">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="9.0.003" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="9.0.003" expanded="true" height="68" name="Retrieve Lake Huron" width="90" x="45" y="34">
<parameter key="repository_entry" value="//Samples/Time Series/data sets/Lake Huron"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="9.0.003" expanded="true" height="82" name="Generate Attributes" width="90" x="179" y="34">
<list key="function_descriptions">
<parameter key="Year" value="date_get(Date,DATE_UNIT_YEAR)"/>
<parameter key="Month" value="date_get(Date,DATE_UNIT_MONTH)"/>
<parameter key="Week" value="date_get(Date,DATE_UNIT_WEEK)"/>
<parameter key="Day" value="date_get(Date,DATE_UNIT_DAY)"/>
<parameter key="Hour" value="date_get(Date,DATE_UNIT_HOUR)"/>
</list>
</operator>
<connect from_op="Retrieve Lake Huron" from_port="output" to_op="Generate Attributes" to_port="example set input"/>
<connect from_op="Generate Attributes" 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>Hope that helps.
Scott
As for parsing, I would use "Generate Attributes" to create separate attributes for each piece you want:
<?xml version="1.0" encoding="UTF-8"?><process version="9.0.003"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="9.0.003" expanded="true" name="Process"> <process expanded="true"> <operator activated="true" class="retrieve" compatibility="9.0.003" expanded="true" height="68" name="Retrieve Lake Huron" width="90" x="45" y="34"> <parameter key="repository_entry" value="//Samples/Time Series/data sets/Lake Huron"/> </operator> <operator activated="true" class="generate_attributes" compatibility="9.0.003" expanded="true" height="82" name="Generate Attributes" width="90" x="179" y="34"> <list key="function_descriptions"> <parameter key="Year" value="date_get(Date,DATE_UNIT_YEAR)"/> <parameter key="Month" value="date_get(Date,DATE_UNIT_MONTH)"/> <parameter key="Week" value="date_get(Date,DATE_UNIT_WEEK)"/> <parameter key="Day" value="date_get(Date,DATE_UNIT_DAY)"/> <parameter key="Hour" value="date_get(Date,DATE_UNIT_HOUR)"/> </list> </operator> <connect from_op="Retrieve Lake Huron" from_port="output" to_op="Generate Attributes" to_port="example set input"/> <connect from_op="Generate Attributes" 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>Hope that helps.
Scott