Transaction data load Transformation mapping - handling empty value - BPC 11.1. std

[KumarPotti]

Hi Mates,

I am trying to load transaction data from csv file.

One of the mapping in transformation file is:

EMP_GRADE=*IF(EMP_GRADE=*STR(0) THEN *STR(NO_GRADE) ; EMP_GRADE)

Here EMP_GRADE field has 0 or empty (i.e. no value) BPC should fill with NO_GRADE.

How to achieve this as tried multiple ways. But I didn't get clue. Even tried to use javascript in conversion file.

Please suggest.

Thanks,

Kumar

[N1kh1l · Accepted solution]

kumar_19

Try this, It will check for both 0 and Blank.

EMP_GRADE=*IF(EMP_GRADE=*STR(0) THEN *STR(NO_GRADE);EMP_GRADE=*STR() THEN *STR(NO_GRADE) ; EMP_GRADE)

In some Service Pack above does not work then try below

EMP_GRADE=*IF(EMP_GRADE=*STR(0) THEN *STR(NO_GRADE);EMP_GRADE+*STR(Z)=*STR(Z) THEN *STR(NO_GRADE) ; EMP_GRADE)

Please upvote/Accept if this helps.

Regards

Nikhil

[KumarPotti]

Awesome. Nikhil.

Both options worked in my system.

Thanks a lot.