I am trying to read csv table, but command results in:
Error reading table P_gen with table handler amplcsv:
Could not find column g in the external table.
The used command is:
set p_gen;
table P_gen IN "amplcsv" "P_gen.csv":
p_gen <- [g];
load amplcsv.dll;
read table P_gen;
The content of csv is:
I am running Windows.
The csv is generated by Julia CSV package. I had everything working properly with xlsx files, but I decided to switch to CSV as I expect loading time should be shorter. I did not expect any issues as excel version works. I suspect this is amplcsv bug and I am not sure how to fix or proceed. I tried adding “1D” and “2D” labels after path specification in the first row of command, but without success.
Adding additional dummy set after g will make it work, e.g. g, set2 or adding empty additional line to the csv, but either of it does not seem like the “proper way”. The CSV was generated from DataFrame table, the same one that was used to generate xlsx file that works, so I thought it should work as CSV as well.