I would like to append Table A and Table B together, and use that newly appended table to overwrite Table A. The purpose of this is to have Table A be updated weekly with the data in Table B within an EG flow, so Table A is up to date when the flow is run. We need Table A to be current, as this is the table that will be appended to and used as the base file. We tried exporting the appended table as a step in the process, however it only allows us to overwrite Table A once. When running the flow additional times, Table A is locked and we cannot append any new Table B's after that. How can we export the appended table and overwrite Table A each time this flow needs to be run? We also need to make sure that when debugging the flow and needing to run it multiple times in one session, we do not perpetually append onto Table A, and would like to put a check in place to see if Table B has already been appended once, and only once.
... View more