Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] DQC Grouping Issue
Go
New
Search
Notify
Tools
Reply
  
[CASE-OPENED] DQC Grouping Issue
 Login/Join
 
Member
posted
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
 
Posts: 4 | Registered: March 20, 2013Reply With QuoteReport This Post
<Kathryn Henning>
posted
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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CASE-OPENED] DQC Grouping Issue

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.