AnsweredAssumed Answered

How to get error message for each record

Question asked by rjadhav952238 on Feb 1, 2017
Latest reply on Feb 2, 2017 by Adam Arrowsmith

Flat File Profile

============

ID

Name

Add

Add2

Phone

Error Message

 

Sample Data : - 

================

IDNameAddAdd 2Phone
1MHMumbai
1John DoeUSLA
1John Doe 2123456789

 

Process Components sequence 

1) Data Shape

2) Bussiness Rule Shape

3) Map Shape

 

 

Date Shape -> 1) split document by profile 

 

Bussiness Rule Shape->

1) Checking mandatory validation (All fields are mandatory).

2) Using Count function on ID - Marked error as  "Duplicate Record". (Count <= 1)

 

Map Shape:

Using same profile at source and destination, assigning error message to each record

 

 

After executing business rule on all mandatory fields and duplicate.In map shape, assigning individual record error message but getting combined error message for all records.

 

Reading Xml from document property - Business Rule Shape

 

Mapping error message from businesses rule message

 

Result After Executing Bussiness Rule Shape :

==================================

IDNameAddAdd 2PhoneError Message
1MHMumbaiDuplicate Record, Name is blank, Add is blank, Add 2 is blank, Phone is blank
1John DoeUSLADuplicate Record, Name is blank, Add is blank, Add 2 is blank, Phone is blank
1John Doe 2123456789Duplicate Record, Name is blank, Add is blank, Add 2 is blank, Phone is blank

 

 

can we assign error message to respective record?

 

Expected Result

==============

IDNameAddAdd 2PhoneError Message
1MHMumbaiDuplicate Record, Name is blank, Phone is blank
1John DoeUSLADuplicate Record, Phone is blank
1John Doe 2123456789Duplicate Record, Add is blank, Add 2 is blank

Outcomes