Avatar

Employee

Hi, I want to remove junk data from my upcoming file loaded in the data loading activity. The enumeration for the Status attribute is as per the following in the schema.

 

Mrityunjay_0-1655720754140.png

But in my flat files, the upcoming data for Status is 

 

Mrityunjay_1-1655720825913.png

 

While I am remapping in data loading like this and setting error processing as ignore the value , The unmatching value is not ignored

 

Mrityunjay_2-1655720917915.png

 

and If I am setting error processing as reject the line when there is no remapping value I am getting this error

Mrityunjay_3-1655721186291.png

can anybody help me out with how to remove junk data, Immediate help will be highly appreciated.