Custno does not exists in the source.

[Former Member]

Hi Experts,

I am trying to load master data from BI to Bpc(Nw). In transformation file i maintained id=custno. Custno is my attribute in Bi side. When i am trying to validate the transformation file the system is showing the followinbg error.

custno is not a valid command or column custno does not exist in source

Error: Validate with data file failed

Kindly help me on this.

Srinivasan.

[former_member198992]

Srini,

In the mapping section of Transformation file,

change the  mapping like in the below way

*MAPPING

ID=ID

do not use mapping

ID=custno

that is the reason for getting that error. I have faced the similar issue and have resoved in similar fashion.

Hope it should help!

Regards

Veera Kommineni

[Former Member]

Hi Srinivasan,

Should it be 0CUSTNO?

Cheers

Sabine

[former_member210696]

Hi Srinivasan,

Check that it is in proper case.

[Former Member]

Hi Experts,

Any help on this.

Srinivasan.