if you are using CSV for output table 1, you can use the append parameter with headers None. Eg:
Unfortunately that means the loss of the column names… You could save you column name elsewhere for later reuse, for instance in a TextDataSet or yamldataset.
Another option would be to use Kedro-Wings which allows you to get around the fact that Kedro does not allow for circular pipelines. You can read your current data on disk, append your new data to it, and save the data to the same location and then reread it by adding “!” at the start of the input name.
However this has the disadvantage of reading a big dataframe from file twice and writing it to file once rather than just reading it once. This can be expensive if you have a big file on disk and you just want to add a small amount of data.
Both methods have advantages and tradeoffs! Hope one meets your needs