I have a filed value that need to be replaced with a value from the same field based on another value in the table. Let's call the field "cost" in the table 'Location". The unique field is "item". In this case , an item exists in multiple locations, field name 'loc'. In each location, a unique item may have a different cost in each location. I need to replace the cost value in tertiary locations from the cost value in the primary location. I have no problem writing a script to replace all values in any given field, but I'm having trouble crafting a script for this process.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!