topic Re: Run-if from DbInput to tMap in Talend Studio

Run-if from DbInput to tMap

Anonymous — Sat, 16 Nov 2024 03:11:49 GMT

Think about this scenario:

1. If the balance of an entry is positive, do some transformation (mapping), and then save the entry into Accounts Payable,

2. if the balance is negative,do another transformation (mapping), and then save the entry into Accounts Receivable

I am trying to use run-if but I am unable to connect the run-f from DbInput to tMap. i can only connect the run-if to a tMsgBox. I am wondering why is that and how to achieve my goal. Very new to Open Studio. Thank you all in advance!

Re: Run-if from DbInput to tMap

nivedhitha — Fri, 21 Feb 2020 17:36:18 GMT

@Dustin ,

That is because tMap has to receive some input from its upstream components. If you are trying to invoke tMap on Run If, it is not receiving any data to process.
So pass the main rows to tMap and create 2 output groups in tMap like shown below using the filter option (where i have added conditions row3.Balance >=0 and row3.Balance <0) to split the data into 2 groups

And map the outputs from TMap to corresponding TDbOutput or whatever you want to do.