Focal Point
[CASE-OPENED] DQC Grouping Issue

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/4107004036

April 24, 2013, 02:35 PM
ABailey
[CASE-OPENED] DQC Grouping Issue
I've got a data file that has "Record" codes of 1,2, and 7. Each record on the
file starts with one of these codes.

1 = Detail Record (AccountNumber,Name, Address, DOB, Balance,YR, Make,
Model,VIN, etc.)

2 = Extra Collateral Record (Yr, Make, Model, VIN)

7 = CoBorrower Record (AccountNumber,Name, Address, DOB, etc)

The 1 and 7 record contain an account number that can be used as a key for
joining purposes. However, the 2 record doesn't contain the account number, but
always comes after a 1 record which contains the account number it belongs to.

Is there a way in DQC I can group the 2 record with the 1 and 7 records without
the account number as the key?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.6
Windows, All Outputs
May 01, 2013, 07:32 PM
<Kathryn Henning>
Hi ABailey,

It looks like you've got an open case that you're currently working on with Customer Support. Please update this topic with the results once you have them.

Thanks and regards,

Kathryn