data store in data set

[Rajee]

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

[bcarlson]

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.

[Rajee]

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.

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....

[Nripendra Chand]

you can read only selected columns from dataset. there is no issue in that.

[Rajee]

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.

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....

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.....

[ray.wurlod]

You can first promote the two subrecords using Promote Subrecords stage.