Data load

  • pgilman
More
18 Dec 2024 16:15 #13723 by pgilman
Replied by pgilman on topic Data load
Hello,

Each row must have data matching the column headings. Rows 746, 1467, 2212, etc. have "x Total" instead of time stamps. Search for "total" to find these rows.

Also, you may need to reorder the rows to start January 1 Hour 0 and End December 31 Hour 23.

Best regards,
Paul.
 

Please Log in or Create an account to join the conversation.

  • Arrey
  • Topic Author
More
19 Dec 2024 00:50 #13725 by Arrey
Replied by Arrey on topic Data load
Thank you. Something else must be going on. Please take a look and tell me why I can still not see my data set.

Please Log in or Create an account to join the conversation.

  • pgilman
More
19 Dec 2024 12:16 #13730 by pgilman
Replied by pgilman on topic Data load
Hello,

The most recent file you attached has only 8757 data rows. It should have 8760 data rows from Janary 1 to December 31 plus the three header rows for a total of 8763 rows.

Best regards,
Paul.

Please Log in or Create an account to join the conversation.

  • Arrey
  • Topic Author
More
19 Dec 2024 13:42 #13731 by Arrey
Replied by Arrey on topic Data load
Thanks, I just fixed that, and nothing changed. Still not loading

Please Log in or Create an account to join the conversation.

  • pgilman
More
20 Dec 2024 12:51 #13733 by pgilman
Replied by pgilman on topic Data load
Hello,

The time stamps for the last few rows in your file are incorrect:

 

There are also some values missing from the second header row.

Attached is a modified version of your file that should work.

Best regards,
Paul.

Please Log in or Create an account to join the conversation.

Moderators: pgilman
Powered by Kunena Forum