It is pretty simple task involving C#, SQL, XML and Pipe separated text file.
1. Create a SQL table and import a pipe separated text file.
2. Create XML file same as pipe separated file and import this XML file into another SQL table
3. Get a column data from 2nd table and update it in 1st table.
4. Export data from first table to pipe separated text file.
I can pay for 5 hours for this task. Please bid only if you are OK with this.
10 freelancers are bidding on average ₹107/hour for this job
I am expert in .net. I can do this in C# and MS SQL server. The generated XML will be having the tables column names, unless you specify any other static xml node/element names