cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert a character to numc

Former Member
0 Kudos

Hello all

In my target i have a field name X  of NUMC type which is mapped to source field Y of NUMC type.

I need to pass a condition in the transformation rule via routine.

The condition is such:

IF field X has value 01 or 03 or 06

THEN field Y = field X  

     ELSE field Y = A

The problem is that A is a character and how to save A in field Y which is of NUMC type?

Please help me out if anyone know the solution.

Kind regards

Riizz

Accepted Solutions (1)

Accepted Solutions (1)

ccc_ccc
Active Contributor
0 Kudos

Hi Rii zz,

Two Approaches:

Approach 1:

  1. Change field Y data type CHAR from NUMC ( so that can update both numc and char values in Y field)

Approach 2:

  1. Where you updating Y = A, instead of A, you may use unique number like 999 etcc, that indicates that Y = A.

Approach 3:

  1. Where you updating Y = A, create new infobject mark "X".



Thank you,

Nanda


Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks i created a new infoObject of type Char. Thanks for your help

Kind Regard

Riizz

ccc_ccc
Active Contributor
0 Kudos

Please check if its works, then select "Correct Answer" and close the thread.

Regards,

Nanda