Solved: Appending Data to a query to a previous query from...

Syndicate_Admin · ‎05-13-2022

I'm trying to build a report that relies on a csv export from a specific web app.

The report coming from that web app only provides data for the last 6 months.

The CSV file is always stored at the same location under the same name, this allowed me to query this file while still allowing this data to be overwritten. The result looks similar to the below:

Table A

The file that has the query then takes the data and puts it through a workflow. The resulting data is then queried within the same file to create a transformed table.

Table B

The challenge is then this, Table A is the result of an export of data that only provides me with a section of the data actually needed

Table B is a query on Table A for columns A and B.

Table A as a result of the export can change as the fields in the web app can be changed, for example, for ID 3, Column B or D could be updated with a new value.

When refreshing the queries in the file, Table A should update and replace all previous content in that sheet. Table B should retain any pre-existing rows and only update with the newly added IDs from Table A. Table A has a column added with a vlookup for the ID into Table B. This allows me to filter out rows that already exist in Table B.

The problem is that because Table B is populated with data from Table A, and the source data for Table A only pull the last 6 months' data, Table B loses information that needs to be retained, but the additional columns also no longer match up with the correct data in column A and B.

Is there anyway I can use Table A to grab the rows for the IDs that do not exist in Table B and insert them into Table B while leaving the rest of the rows in Table B unchanged?