change data capture - How can I preserve certain fields?
Posted: Thu Mar 31, 2016 3:07 pm
Hello,
I have two flat files with this format.
file 1
id|desc|value|
1|test1|123
2|test|256
3|test2|951
file 2
id|desc|value|
1|test1|999
4|test|256
6|test2|951
I join these 2 files in one. Where ID is the same i put them together in one line. I need to know how can i preserve the value for field "value" from the file 1 and not the file 2
This is my result
1|test1|123
2|test|256
3|test2|951
4|test|256
6|test2|951
this is what i expect
1|test1|999
2|test|256
3|test2|951
4|test|256
6|test2|951
Can I use join or lookup? or maybe CDC?
thanks for your help.
I have two flat files with this format.
file 1
id|desc|value|
1|test1|123
2|test|256
3|test2|951
file 2
id|desc|value|
1|test1|999
4|test|256
6|test2|951
I join these 2 files in one. Where ID is the same i put them together in one line. I need to know how can i preserve the value for field "value" from the file 1 and not the file 2
This is my result
1|test1|123
2|test|256
3|test2|951
4|test|256
6|test2|951
this is what i expect
1|test1|999
2|test|256
3|test2|951
4|test|256
6|test2|951
Can I use join or lookup? or maybe CDC?
thanks for your help.