Expand my Community achievements bar.

SOLVED

Regarding removing junk data from upcoming file

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.

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

hello @Mrityunjay,

 

You have to increase the threshold from which a workflow error is triggered: 

 

Amine_Abedour_1-1655729653362.png

 

Br,

 

Amine

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

hello @Mrityunjay,

 

You have to increase the threshold from which a workflow error is triggered: 

 

Amine_Abedour_1-1655729653362.png

 

Br,

 

Amine