Skip to Content
avatar image
Former Member

How to convert a character to numc

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 05, 2015 at 08:01 PM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2015 at 09:59 PM

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

    Regards,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 10, 2015 at 05:21 PM

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

    Kind Regard

    Riizz

    Add comment
    10|10000 characters needed characters exceeded