HOW LO LOAD BLANK VALUES INTO BPC

[Former Member]

Hi,

I have to load Blank values into BPC.

Blank values should be mapped to I_NONE.

For non blank values I_C should be added as prefix.

The condition in transformation file under Mapping section is

INTERCOMPANY=*If(0FG_IDTP =*STR() then *STR(I_NONE); *str(I_C)+0FG_IDTP)

but this logic is not valid.

Can anyone correct this Mapping.

Thanks,

Sindhu

[Former Member · Accepted solution]

Hi Sindhu,

Try the below.

INTERCOMPANY=*IF ( *STR(Z) + 0FG_IDTP = *STR(Z) then *STR(I_NONE); *STR(I_C)+0FG_IDTP)

Regards,

Gokul.N

[Former Member]

Hi Sindhu

Try the following. I have used it and it works.

INTCO = *IF(0PCOMPANY=*str() then *str(I_NONE);0PCOMPANY)

Then to add the I_C to the id's you can use the conversion file.

Regards

Jigar

[Former Member]

Hi Jigar,

I tried it already. I t didn't work.

Thanks,

Sindhu