AnsweredAssumed Answered

Useful Step for Switching Empty Query Results

Question asked by Roguen Keller Employee on May 21, 2018
Latest reply on May 22, 2018 by Roguen Keller

TL&DR: Can anyone recommend a step or method for switching the flow of my transformation in the event that my MongoDB input step comes back with 0 results?

 

More detailed explanation: I want to capture the results from my query in the MongoDB input step as well as events where that query returned 0 results.

I had a look at the Switch step, but I didn't see a way to do what I wanted using that. Can anyone recommend as method for this?

MongoDB itself does have a switch and conditional statements in there queries in their latest version, but do to this limitation, DI - MongoDB Aggregation broken with MongoDB 3.6, I had to revert to an older version (3.2)

 

Using PDI 7.0 EE

Outcomes