Copy Rows with condition

Wanahmad
Participant II

How to write an expression in virtual column to copy rows in one table to another table when a condition is true.

0 3 334
3 REPLIES 3

Would you please open your request with little more details, thanks.

Sorry for the lack of information. Its like this. I am trying to copy row/rows(including all columns of data from table A to table B when โ€œCompleteโ€ is entered in column 146. If โ€œIncompleteโ€ is entered nothing will happen. All columns in both Table A and B has the same name. Table A is for Application and Table is for Processing. One more condition to add is, if data in column 106 (AGENCY) is โ€œGovโ€, the first condition โ€œCompleteโ€ is not necessary, the row will be copied to Table B.

May I ask why do you want to copy the data? Could it be possible to just change the Status fieldโ€™s value to โ€œCompleteโ€ without copying the data?

Top Labels in this Space