How to convert a character to numc
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.
Nanda Anantha replied
Hi Rii zz,
- Change field Y data type CHAR from NUMC ( so that can update both numc and char values in Y field)
- Where you updating Y = A, instead of A, you may use unique number like 999 etcc, that indicates that Y = A.
- Where you updating Y = A, create new infobject mark "X".