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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RV1652730475
Contributor
Contributor
‎2022-05-23 10:03 PM

Incremental Data Load is Failing if there is no data coming from Source

Hello,

I'm loading data from Mongo to Oracle Database. This is an incremental data load. If for the given day, there is no data coming in based on start and end dates, than I want the job to quit. But instead it is getting NULL values for all the columns. Can you please help me of how I can quit the job without any failure when there are no records coming in from Source. I've tmap here for data type conversions between source and target.

Here is the screenshot of my job :

0695b00000RiJALAA3.png

Labels (5)
Labels
321 Views
0 Likes
1 Reply
SamuelLenk
Contributor
Contributor
‎2022-10-25 06:43 AM

Your component tMongoDbInput has a variable NB_LINE thats available after execution.

So you could like shown in the picture working with IF to either tDie or continue processing.

HTH! Kind regards, Samuel

https://talend-training.com/

0695b00000YDe7OAAT.png

321 Views
0 Likes