Database Query and Row Insert

Hi Everyone,

I am importing data through a CSV query. This query updates the two left columns in a single table, shown in Fig. 1 as the two large black boxes (Global PMT Name and Subsystem). The 'x' marks to the right are within the drawn table but are not a part of the query.

In my test, I have inserted a new row into the queried CSV and have named it 'TEMP', shown below in Fig. 2. Although I have my query setup to add entire new rows for new data, the expansion is inconsistent when I refresh my data. Six 'x' marks have shifted down correctly, but the rest of the below data has not shifted or has shifted incorrectly.

Any insights?

Figure 1. Pre-query update.

Figure 2. Post-query update. Notice that some of the 'x' marks have shifted down (blue), but most of them have not. The row shifting is inconsistent.

Figure 3. Query settings.