Skip to Content
avatar image
Former Member

Create target Element IF

Hi Guys,

I need so tips about how to make this logical below:

Source to Target - (Element - KEY).

The element KEY must be not created with there is no LOCAL_PI_ID, because KEY it's WHERE to JDBC interface and the select will be:

SELECT * FROM TABLE WHERE - Will generate error.

If there is no LOCAL_PI_ID - Do not create KEY

If there is LOCAL_PI_ID - Send ROW - LOCAL_PI_ID to KEY - LOCAL_PI_ID

If there are COUNTRY_CODE or LOCAL_DRUG - Send ROW C or L to KEY C or L.

I need make this comparison from those 3 input fields to KEY.

Thank you guys !

Regards,

untitled.png (10.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 17, 2017 at 11:48 AM

    Hi Pedro!

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 09:17 AM

    Try this.

    LOCAL_PI_ID-->Exists-->CreateIf-->KEY

    LOCAL_PI_ID-->LOCAL_PI_ID

    COUNTRY_CODE-->Exist-->If-->then pass COUNTRY_CODE Else pass LOCAL_DRUG

    --Priyanka

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 09:54 AM

    Hi Pedro!

    Wouldn't you please clarify your requirement? Do you have three possible conditions like:

    WHERE LOCAL_PI_ID = Value

    WHERE COUNTRY_CODE = Value

    WHERE LOCAL_DRUG = Value

    ?

    Or combination of that conditions?

    Regards, Evgeniy.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 17, 2017 at 08:03 PM

    Change the context of LOCAL_PI_ID to the root node, then map to key;

    Change the context of LOCAL_PI_ID to the root node, then splitByValue (each value), then map to target LOCAL_PI_ID.

    Add comment
    10|10000 characters needed characters exceeded