Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Run-if from DbInput to tMap

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!

Labels (3)
1 Solution

Accepted Solutions
nivedhitha
Creator III
Creator III

@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 groups0683p000009M97X.png

 

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

View solution in original post

1 Reply
nivedhitha
Creator III
Creator III

@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 groups0683p000009M97X.png

 

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