Hi,
Kindly clarify if there is any way to write only the key column value of the compared files to the first,second columns of the compare stage's output link instead of writing the whole record and also the method to read the data from data set.
Thx,
Rajee
data store in data set
Moderators: chulett, rschirm, roy
I am comparing two flat files through compare stage and storing the result in the data set...later i need to use the data set to extract the key colums and log the discrepent records....bcarlson wrote:If you want a dataset with just the keys, use a modify stage after your compare. Either specify DROP and list the columns to drop, or specify KEEP and list the columns to keep.
When you say 'read the data from data set', what do you want to do with it? We need more info.
Brad.
-
- Premium Member
- Posts: 196
- Joined: Tue Nov 23, 2004 11:50 pm
- Location: Sydney (Australia)
The compare stage returns only 3 columns to the output link ie one is result,the other two are first and second in which the first column holds the entire record details of source 1 and the second holds the entire record of record 2.in such case how can i use modify stage.....Rajee wrote:I am comparing two flat files through compare stage and storing the result in the data set...later i need to use the data set to extract the key colums and log the discrepent records....bcarlson wrote:If you want a dataset with just the keys, use a modify stage after your compare. Either specify DROP and list the columns to drop, or specify KEEP and list the columns to keep.
When you say 'read the data from data set', what do you want to do with it? We need more info.
Brad.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: