How to remove duplicate column names in Schema out in BODS

[former_member101281]

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

[denise_meyer]

You cannot have duplicate column names in Data Services, so you will have to find another way by changing the column name on the excel or csv source to load to BW.