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
Get 'change value' column values of both before and after ds
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: