Redirecting failed records to a new table while reading data from kafka pipeline

we can skip the failed records by setting up a pipelines_stop_on_error state to OFF
Because of this records loss is happening…
Instead of skipping the failed records , is there any way to redirect the failed records to a different table ?