Skip to Content
0
Jan 21, 2020 at 03:36 AM

How to remove duplicate column names in Schema out in BODS

307 Views

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