C
cisq1
hi , i have 2 x files
file 1
col1 col2 col3 col4
abc 123 text1a
def 456 text2a
def 789 text3a
ghj 456 text4a
file2
col1 col2 col3 col4
abc 123 text1
def 456 text2
def 789 text3
ghj 456 text4
after i combine them i am trying to
1. if data in col1 and col2 are the same then take data in col3 (was from
file2) and replace it into col3 of file 1.
2.then delete that row (ie the row originally from file2)
end result like this
file 1
col1 col2 col3 col4
abc 123 text1 text1a
def 456 text2 text2a
def 789 text3 text3a
ghj 456 text4 text4a
hope that makes sense .
file 1
col1 col2 col3 col4
abc 123 text1a
def 456 text2a
def 789 text3a
ghj 456 text4a
file2
col1 col2 col3 col4
abc 123 text1
def 456 text2
def 789 text3
ghj 456 text4
after i combine them i am trying to
1. if data in col1 and col2 are the same then take data in col3 (was from
file2) and replace it into col3 of file 1.
2.then delete that row (ie the row originally from file2)
end result like this
file 1
col1 col2 col3 col4
abc 123 text1 text1a
def 456 text2 text2a
def 789 text3 text3a
ghj 456 text4 text4a
hope that makes sense .