:)Transformation logic on column values in two different files,
File A
12345,000,4444, HKD3.5
12346,000,5555, HKD3.5
File B
12345,4444,54321,6666
12346,5555, 64321,7777
12347,5555, 65321,8888
Requirement as below
1.read file A
2. match with File B ie
if (fileA.column1 =fileB.column1 and fileA.column3=fileB.column2) then
new_val1=fileb.column3
new_val2=fileb.column4
end if
I would appreciate for your gr8 help on this.
Thanks and Regards,
HAA