I have been working this issue for 2 days now. This has happened to me in the past and I was able to work through it. It doesn't appear that this time I am going to be so lucky.
Issue Description:
When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created.
Troubleshooting steps:
I have read this article:
http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx
This was the solution the last time I had this problem. However, no matter what I do, it is not working now. I have a column named
User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow. When the workflow kicks off, it reads this column and attempts to get the value. The value is blank because a
new column with the name User Name now exists and that is where the value is stored. I attempted to fix it by remapping the GUIDs as described in the article. I also reverted the code to a previous version from TFS. None
of these worked.
I now have 3 columns called
User Name and I can remap the GUID to the second column and third column. But when I try to map it to the first column (the one I need) it doesn't work.
The first column that is circled is the correct column. 
View Complete Post