Get 'change value' column values of both before and after ds

[harshada]

Hi,

When we use a change capture stage on a before and after dataset, we get the 'keys' and 'change value' of only the AFTER DATASET in the output. Is there a way to get the change value of the before dataset as well.

for eg

before dataset

col1, col2, key
a b 1
a c 2



after dataset
col1,col2,key
d b 1
e b 2


change cap state -> key ='key' col
change value='col2' col

in the o/p wanted to have both the before and after values of change value i.e col2, is it possible to get it?

Please help

Thanks

[ray.wurlod]

Not without using a different stage type.

[harshada]

Hi Ray,

Which stage would suit here then... I used change capture as I wanted to compare one file with respect to other on a key and change value column.

Is there a better option?

[ray.wurlod]

Try Compare or Difference stage type.