All Topics | Topic: “How to change my CSV to read it from WEAP?”
Author Message
Mr. Amin Daghighi
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?”