How to get rejected rows in Dataprep

Four Stars

How to get rejected rows in Dataprep

Hi,

With Data Preapration iam getting only Cleaned Output. 

Is there any way to get the rejected rows in Datapreparation

Moderator

Re: How to get rejected rows in Dataprep

Hi,

 

With the current version, you cannot natively retrieve the rejected records. That is something we're considering for the next versions.

 

In the meantime, a (not-so-elegant) workaround is to add a column to your dataset and to input a specific value in this column for records which aim to be rejected instead of removing the records. This way, by filtering on this column, you can export only the valid records or only the invalid ones.

 

Regards,

 

Gwendal

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads