Geeks With Blogs

Lance's TextBox October 2011 Entries
Merge Delimited Files on a Common Key
Many times I need to merge two separate datasets that have a common key column – for example: dataset 1: ID, Name, Weight, Height dataset 2: ID, Address1, Address2, Phone1, Phone2 I can’t just concat the data together, instead I need the merge to happen around the ID key, so that each ID only has a single row in the result. So, of course I wrote a powershell script to do this for me. Take a look at it below. I called it “Merge-TsvFiles”, but it takes a delimiter as one of its paramters, so you could ......

Posted On Tuesday, October 18, 2011 1:17 PM

Copyright © Lance Robinson | Powered by: