Copying only filtered data from a single column-CodePudding

I am trying to copy only one column from a filtered raw file onto a working sheet. Both are sheets within the same spreadsheet.

I found this entry

The sample code:

function filteredCopy() {

  // rename the sheets with the actual name of your worksheets. 
  const sheet = SpreadsheetApp.getActiveSpreadsheet();
  const sourceSheet = sheet.getSheetByName('raw');
  const temp_targetSheet = sheet.getSheetByName('filter_data_raw');
  const targetSheet = sheet.getSheetByName('target');

  // gets the filter data
  let sourceRange = sourceSheet.getFilter().getRange();

  // copy and paste the data in the helper worksheet
  sourceRange.copyTo(
    temp_targetSheet.getRange('A1'),
    SpreadsheetApp.CopyPasteType.PASTE_NORMAL,
    false);

  // select the column that you want to copy, in the case of my dummy data 
  // I used the column E

  let range_1 = temp_targetSheet.getRange("E:E");

  // copy the column to A1, you can use AP2 base on your code
  range_1.copyTo(
    targetSheet.getRange('A1'),
    SpreadsheetApp.CopyPasteType.PASTE_NORMAL,
    false);

  // make sure that all the values in the sheet are up to date

  SpreadsheetApp.flush()

  // clear the information on the temp sheet
  // to make sure everything ready for a new run

  temp_targetSheet.getDataRange().clearFormat();
  temp_targetSheet.getDataRange().clearContent();
}