Skip to Content
avatar image
Former Member

JDBC lookup Issue

Hi Experts,

I have JDBC lookup which is fetching one field from JDBC.If there is no value in that field than I want to add that file in one file.

How to do it.

thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 23, 2015 at 09:20 AM

    Please suggest the away

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2015 at 09:45 AM

    Hi Shikha,

    So if i understand correctly you want to add a value in target payload if their is no value being fetched by JDBC look up is that right ? if yes then you can have an if else condition for this.

    Br,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2015 at 06:43 PM

    Hi,

    Is it throwing an error when it is not fetching any values? You can check the output of the lookup when there are no values and can match accordingly to if else conditions.

    Please provide error details in case of no values, in case it doesn't work.

    Thanks,

    Nidhi

    Add comment
    10|10000 characters needed characters exceeded