DSXchange

Gurus,

We have error table structure as below.

KEY
SRC_CLM_NM
SEVERITY_FLG
ERR_DESC

We are planning to reject the error to error table for invalid data or databease rejects. The problem is we need seperate row for each data problem i.e. a row got rejected due to 3 reasons like invalid date, key not found in lookup etc for this scenario there should be 3 entries in error table.

I'm able to make a sigle entry in DB with concatinating the errors in ERR desc column with message like error1:| :error2 etc.

But we need every error to be in seperate row. I tried using the field function but then we do not know how many errors will be there at run time and also its not working as expected as for err_desc column i can have one derivation only.

Regards,

Pivot stage would solve this nicely

ArndW wrote:Pivot stage would solve this nicely

But its one row the i.e

key src ERR_DESC
1 ABCD ERR1: ERR2:ERR3

To convert to

1 ABCD ERR1
1 ABCB ERR2
1 ABCD ERR3

And ERR_DESC columns error are decides on run time , we do not know how many errors will be there in a row at time of processing it may be 1 0r 10.

Regards,