Skip to Content
author's profile photo Nidhi Srivastava
0
Nidhi Srivastava

If then else suppressing values due to EXISTS function output

Posted on Apr 17, 2020 at 11:49 AM 150 Views

Hi Experts,

I am stuck in a issue, where it the Exists function is returning "true" it is working perfectly fine but if it is returning "false" then the else value passed(10 values in the queue) are suppressed & only the first value is produced as an output.

We need all the 10 values to be passed in the output. Please suggest any workaround.

Thanks,

Nidhi Srivastava

issue1.jpg (46.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Nidhi Srivastava
    Nidhi Srivastava
    Posted on Jul 14, 2020 at 11:31 AM
    0

    Hi All,

    It didn't worked as expected. Tried a workaround - duplicate node and similar kind of mapping rules. Closing the blog.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Pavan G
    Pavan G
    Posted on Apr 17, 2020 at 12:55 PM
    0

    Hi Nidhi,

    If You want to pass all the ten vales, use remove context and splitbyvalue(eachvalue) before passing the values.

    Also, try altering the contexts. Both should have the same contexts to pass the same number of values.

    When I faced the similar issue, I tweaked contexts of the source field to resolve the issue.

    Regards,

    Pavan

    Add a comment
    10|10000 characters needed characters exceeded

    • Pavan G
      Apr 20, 2020 at 07:14 AM

      Hi Nidhi,

      In my case, it worked.

      Can you try altering the mapping logic as below considering only one money field will be populated?

      If InvoiceDetailItem exists, then pass the Money in If value, else {add one more if-condition} InvoiceDetailServiceItem exists then pass the Money in else value, else a constant empty value. You can play with context to generate the correct output.

      If the above solution doesn't work, then you have to use UDF to generate the contexts.

      Regards,

      Pavan