Time Series Data Append (Using Table Designer)

The platform allows structured time-series data management using the Table Designer interface. This feature enables users to append new rows, edit existing records, and manage tabular data safely without breaking the dataset structure.

---

Step 1: Upload the Initial Dataset

1. Go to Add Dataset.
2. Fill in the dataset details.
3. Upload a tabular file (CSV or Excel) as a resource.
4. Click Finish or Review.

Once uploaded, the dataset page will display the resource file.

---

Step 2: Prepare Resource for Table Designer

To enable structured time-series management, the uploaded file must be converted into a managed table format.

1. Open the dataset page.
2. Click the uploaded resource.
3. Click Edit Resource.

Screenshot: Edit Resource


4. Click Clear Upload.
5. Click Remove to confirm.
6. Click the Table Designer button.

---

Why Clear Upload?

Clear Upload removes the original uploaded file so that the resource can be converted into a structured database table. This allows:

• Row-by-row editing
• Appending structured time-series data
• Validation during updates

---

Why Click Remove?

After clearing the file, clicking Remove confirms the deletion of the uploaded file. This does not delete the dataset — it only prepares the resource for structured table management.

---

What is Table Designer?

The Table Designer converts the resource into a structured data table stored in the system. It allows:

• Adding new rows
• Editing existing rows
• Deleting rows
• Appending bulk time-series data
• Editing data directly in Excel format

---

Step 3: Download Append Template

Inside Table Designer:

1. Click Download Excel Template.
2. A template file will be generated.
3. Download and open the file.

This template ensures that new time-series data follows the correct structure.

---

Sample Template Structure

The downloaded template contains the required columns. Do not modify column names.

---

Step 4: Add New Time Series Data

• Add new rows below the existing structure.
• Maintain correct date/time format.
• Do not change column headers.

Save the file after entering new data.

---

Step 5: Upload Template to Append Data

1. Return to Data Resource page.
2. Click Upload Template Data.
3. Select the updated template file.
4. Confirm upload.

The system validates and appends the new rows to the existing dataset.

---

Managing Data Inside Table Designer

At the top of the preview table, several options are available:

• Add Row – Insert a new record manually.
• Edit Row – Modify selected row values.
• Delete Row – Remove selected row.
• Edit in Excel – Open and edit the table in spreadsheet format.

---

Step 6: Verify Updated Data

After appending or editing:

• The table refreshes automatically.
• New rows appear at the bottom.
• Changes are saved immediately.

---

Important Notes

• Column names must not be changed.
• Data types must remain consistent.

This structured workflow ensures reliable time-series updates without overwriting or corrupting existing data.