Hi Friends,
Need you help!
i have a flat file which has old value and corresponding new value. I need to check the input that i get with old value & move the corresponding new value to it.
Input file :
ws-bkr=0014
crossreference file:
old value new value
0014 0015
0016 0015
0017 0015
currently whatever i have in my input file is moved directly to output file.
Output file
ws-bkr=0014
what i require is i need to lookup reference file and move the new value from reference file to putput file
output file
ws-bkr=0015
Please let me know how we can acheive this using arrays. Some code snippet if possible.
Thanks in advance