Veda2.0 Released!


Including rows with "zero" in VEDA BE Tables
#1
I have a quick question!

When I want to have a Table in VEDA BE, I select related Attributes, Commodities, etc. and then VEDA BE producing the Table. However, it dose not show the rows which all of the data are "zero". I want to export the data to an excel file and I want to have all of the combinations of the selected Attributes, Commodities, etc. in the Tables; even if the data is zero in all of the time-slices. 

How can I take care of this issue? Thank you for your help!
Reply
#2
See file times2veda.vdd in GAMS_Src folder. There is a line "not-0 ". This suppresses records with zero values for these variables to check the size of VD files. Commenting this line out should bring in the zeros that you are looking for.

But you could also manage this in Excel if you use formulas to populate a fixed structure that reads from a CSV dump out of VEDA-BE.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Error import results to VEDA-BE due to access 2GB limit [email protected] 9 11,684 20-05-2020, 03:09 PM
Last Post: AKanudia
  Autoformat options for VBE export tables JGlynn 2 4,664 26-04-2020, 08:23 PM
Last Post: JGlynn
  Trial version veda BE MohammedAbiAfthab 0 2,508 16-07-2019, 05:54 PM
Last Post: MohammedAbiAfthab
  Importing predefined tables, existing predefined tables accidentally deleted [email protected] 5 7,634 10-07-2019, 11:30 AM
Last Post: Vikrant
  VEDA Backend Export Interruption SEM 6 13,904 30-08-2018, 10:13 PM
Last Post: SEM
Sad VEDA-BE won't open database DAYANG 4 9,063 26-06-2018, 03:32 PM
Last Post: DAYANG
  "Missing Tables" error message Giulia Realmonte 0 3,001 13-06-2018, 08:58 PM
Last Post: Giulia Realmonte
  Problem with database since installing new VEDA-BE DanWelsby 5 13,643 05-01-2018, 06:10 PM
Last Post: Antti-L
  Veda BE "Error 0" tnapp 9 22,528 14-10-2017, 09:18 PM
Last Post: AKanudia
  VEDA-BE v4.9.9 always adds a "Scenario" row to tables pedodds 1 6,756 12-08-2017, 11:02 PM
Last Post: AKanudia

Forum Jump:


Users browsing this thread: 1 Guest(s)