I have 2 different fields most of the values for these two fields are same except one or 2 values.
Even though the two field values differ one value is "local" and another value is "Sports Local" they basically represent the same value. So my requirement is i want to combine these two fields into one and make the values uniform.
Attached are the excels with the sample and expected results.
Thank you,
Ramya
Message was edited by: Ramya Sai
Sorry i have attached a wrong data files. So corrected it and updated the the correct data files. Sorry about it. Thank you,
Ramya
Actually i have multiple field values to be renamed so created an inline mapping table and resolved the issue. Really appreciate all your help. Thank you,
