Hi
We have a requirement to load data to BW system form CSV files,while loading data to BW system target table consists duplicate column names,so my source CSV file also having same column names,however BODS does not allow duplicate column names in schema out.
e.g:
Target table\source csv column names:
1.PERNR
2.BXEG
3.PERNR
4.BUDAT
5.PERNR
I have to load same PERNR column into BW target table.
while doing mapping am getting below error.'
"The column name 'PERNR' has been used.please enter another name.(BODI 1220495)"
Please suggest an alternate on this without editing the column names.
Regards,
Mahesh