This content has been marked as final. Show 2 replies
I would start by ensuring that your first column with "2002" is actually text. When saving the text file this could have been tagged as a numeric column and this could cause the problem you are seeing.
I would start by opening the Load Rule, then opening the data file inside to Load Rule to ensure that the Rule reads the data the way I expect it to.Be aware that if the data file has fewer columns than the Load Rule, the remaining columns of the Rule will not show up in the Data Prep editor! Know how many columns the Rule expects before you open the data file.If no luck there, I would try a data load and force an error. The error log may give some clues as to which column the problems resides.Good Luck,Tim