Hi guys, I ran into the following problem;
I have a file with this format:
R;21122016;01012017;31012017;20000000028;D;N;N;4,00;16;
R;21122016;01012017;31012017;20000125327;C;N;N;4,00;16;
that I have to import into a table using the data management framework. Obviously the column delimiter is the semicolon and the row delimiter is CR;LF. Now, the thing is that when I try to generate the source to staging mapping, I get this error:
which I'm guessing is due to two columns having the same field. I changed the name on the field just to see where would that get me, and I got this other error at the time of mapping the fields:
I'm getting an empty column from the source, and I can't complete the mapping... I tried adding a column to the staging table so I can map the empty field on the source to that one, but I got an error when I tried to regenerate the mapping. Does anyone have any idea how to get around this issue without changing anything in the source file?
*This post is locked for comments
I have the same question (0)
