Skip to main content

Re-importing CSV Data to My Glide Table

This article explains how to reimport a CSV file with data from the same table.

Updated over a week ago

Importing data into a Glide Table can be challenging when your CSV file contains data that was previously in the table. If you find that importing the data fails without showing any errors, it might be due to duplicating row ids. Here’s a step-by-step guide to navigating this issue:

Step-by-Step Guide

1. Prepare Your CSV File

Begin by opening your CSV file. You'll notice there's a column named 'Row ID', which is essential for identifying rows uniquely. Rename this column to something else, such as 'Row ID 2'. This simple renaming helps to differentiate between the old data and the new import.

2. Import the CSV File

Once the 'Row ID' column has been renamed, proceed to import your CSV file into the Glide Table. This action incorporates the new data without overwriting the existing records.

3. Create an If-Then-Else (ITE) Column

Now, to ensure that all data is accounted for and correctly linked, it's important to create an If-Then-Else column. In this column, configure the logic as follows:

  • If Row ID 2 is empty, use Row ID.

  • Else, use Row ID 2.

This configuration makes sure that for any given row, it utilizes the original 'Row ID' unless a 'Row ID 2' is present.

4. Utilize the ITE Column

After setting up the If-Then-Else column, you can now use this column to create relations within your data. By doing so, you effectively maintain data integrity, ensuring no data is lost or left unlinked during the import process.



Did this answer your question?