How to not execute the "Catch lookup inner join reject" flow from tMap

[Anonymous]

Hello,

I'm facing a problem when trying to make a execution flow with tMap using the feature "Catch lookup inner join reject". In the flow below, I'm getting only the data that doesn't exist in the db table to insert it. However, I want to catch this data after the insert, to save the pk that was inserted in a global variable. The problem is that even if not exist data to be inserted (as you can see the stats 0 rows in Main order:2), the component tDBInput_2 is always called, causing an issue, because in this component I'm selecting the currval of a sequence, that is inserted by the dm_merchant component, that is never called.

Exist some way to execute the tDBInput_2 only if exist records in the Main order:2 connection flow?

NOTE: Another doubt is that I'm using two tSetGlobalVar to save the same variable, that is the pk inserted or selected by the tMap; exist some component to join these flows so I can call the tSetGlobalVar once?

Thank you!

[TRF]

Use trigger "If" instead of 'OnComponentOK" (use global variables associated to "dm_merchant" to decide to continue or not).
For the 2nd point, you can let as is.

[Anonymous · Accepted solution]

Thank you @TRF,

As a workaround, I changed the tDBOutput to tDBRow with a returning statement to get the pk inserted. Then, to get the returning query, a used a tParseRecordSet --> tSetGlobalVar. With this, the flow worked.

Luiz