All Topics |
Topic: “How to change my CSV to read it from WEAP?”
Author | Message |
---|
Subject: How to change my CSV to read it from WEAP?
Posted: 10/2/2017 Viewed: 14475 times
Hi I have a CSV file but it says I cannot read the file because of duplicate!
From excel: # Streamflow for Weaping River: Below Downstream Requirement # Calculated by WEAP: 9/1/2016 4:06:32 PM # Area: Weaping River Basin # Scenario: Supply Measures $ListSeparator = , $DecimalSymbol = . $Columns = Year $Columns = Month Streamflow[CMS] 2010 1 142.06 From Notepad copy pasted: # Streamflow for Weaping River: Below Downstream Requirement,, # Calculated by WEAP: 9/1/2016 4:06:32 PM,, # Area: Weaping River Basin,, # Scenario: Supply Measures,, ,, "$ListSeparator = ,",, $DecimalSymbol = .,, $Columns = Year,$Columns = Month, Streamflow[CMS] ,, 2010,1,142.06 2010,2,119.53 2010,3,209.79 2010,4,286.26 2010,5,128.08 2010,6,44.5 2010,7,23 2010,8,43.5 2010,9,27 2010,10,58.5 2010,11,158.86 2010,12,172.96 this is the type of my csv and rest of the file is just numbers Please help me to revise it Regards, Amin |
Topic: “How to change my CSV to read it from WEAP?”