Get 'change value' column values of both before and after ds
Posted: Wed Apr 06, 2011 2:55 pm
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
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