Hello! The way I understand the “append” function is that it should take the output of the conversion and add that data to an existing spreadsheet.
I guess my first question is… Is that correct? If yes, I need a bit of advice on how to set it up.
Basically I have a spreadsheet of data we are keeping, call it “spreadsheet A”. Im creating a new transformation and one of the outputs will be the same data as spreadsheet A. What I would like to do is have the output add that data to spreadsheet A. However, when I try to create that output and select spreadsheet A as the location of the output, it gives me the “the current file exists, do you want to override.”
Am I doing something wrong?