How to Preserve Queried/Looked-up Values

[smallpond]

Hello,
I have a Glide table (Table A) that pulls data from another Glide table (Table B, which syncs with a Google Sheet) using a Query and Lookup setup. For example, Column 1 in Table A gets numeric values from Table B as new data is added daily in the Google Sheet.

To manage row limits, we regularly delete old rows from Table B. The problem is: once those rows are deleted, the relation breaks, and the data in Column 1 of Table A disappears.

What I want to do is preserve the looked-up values (as static numbers) in Table A automatically everyday—so we retain the historical record.

Question:
What’s the best way to automate this everyday without causing too many updates?

Thanks in advance for any suggestions or tips!

[Hassan_Nadeem]

You can use Scheduled Workflows, but they’ll end up costing a lot of updates over time. I think your best option is to create a non-computed basic number column in Table A, and manually copy the entire Lookup column into it.

It won’t be automatic, but it’s a quick one-time step you can do before deleting the old rows from Table B. The best part is it won’t use any updates at all

[smallpond]

@Hassan_Nadeem Thank you for your quick response and insights!