Copy cells from a table to another table with conditions.

Hello everyone.

I am trying to build an Excel script that basically follows the next steps:

1. Look for the last row added to the table.
2. Search for questions that have been answered as "Yes".
3. If it founds a "Yes" value, it must copy the cell right next to it to another table, which is the answer given by the user. And also the name, nationality and age.

Original Table (picture 1):

Table 1.jpg

Expected Table Result (picture 2):

Table 2.png

Here is the Excel file.
Survey Trial (1).xlsx

I will be very attentive to your answers. Thank you in advance.

You can try the script below. I show that it is working with the file you provided:

function main(workbook: ExcelScript.Workbook) {
let inputTbl = workbook.getTable("Table1")
let outputTbl = workbook.getTable("Table3")

let nameCol = inputTbl.getColumnByName("Name").getRangeBetweenHeaderAndTotal().getValues() as string[][]
let nationCol = inputTbl.getColumnByName("Write your nacionality.").getRangeBetweenHeaderAndTotal().getValues() as string[][]
let cityCol = inputTbl.getColumnByName("Choose you city.").getRangeBetweenHeaderAndTotal().getValues() as string[][]
let ageCol = inputTbl.getColumnByName("Write your age.").getRangeBetweenHeaderAndTotal().getValues() as string[][]

let inputVals = inputTbl.getRangeBetweenHeaderAndTotal().getValues() as string[][]

let inputRowCount = inputTbl.getRangeBetweenHeaderAndTotal().getRowCount()
let inputColCount = inputTbl.getRangeBetweenHeaderAndTotal().getColumnCount()
let tempArr: string[][] = []

for (let i = 0; i < inputRowCount; i++) {
for (let j = 0; j < inputColCount; j++) {
if (inputVals[i][j] === "Yes") {
let finding = inputVals[i][j + 1]
let temp: string[] = [nameCol[i][0], finding, nationCol[i][0], cityCol[i][0], ageCol[i][0]]
tempArr.push(temp)
}
}
}

outputTbl.addRows(-1,tempArr)

}