Skip to Content
avatar image
Former Member

blank field need to replace by constant

Hi Experts,

I have one field which will have some times value and some time blank value so I wanted to replace blank field value from constant how can I achieve this.

Tx

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 03, 2015 at 11:44 AM

    Hi You can try something like this. you have to use exists command and if not exists then replace with constant. currently I don't have access to PI system so cannot give you graphical solution.


    Mapping.JPG (23.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 12:01 PM

    Hello Ramesh,

    you can use map with default function which will pass the actual value if value exists else whatever value you have mentioned will be passed.

    or

    you can compare the input value with blank constant if yes pass pass the required value else the actual value.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 03, 2015 at 04:54 PM

    If the field does not exist, mapWithDefault would work. If the field is blank, you can put an If-Else block.

    Add comment
    10|10000 characters needed characters exceeded