how to use test data when there is no record in source data?

I am feeding my source data into 'Dynamic Input In-DB' tool after doing some filters. Sometimes, I get zero records after applying filters and as a result Dynamic In-Db tool throws error. How can i update my workflow to use a test data to feed into Dynamic In-DB; when there is no record from source data?

Dynamic Processing

Preparation

Accepted answers

All comments

aatalai

@ayush_mishra

can you stream out and use the test tool setting the expecting number to 0?

something like this

streamout and test.PNG

ayush_mishra

hey @aatalai, here is a snapshot of my workflow

aatalai

@ayush_mishra would a test tool not work in this case?

ayush_mishra

nope

aatalai

ok what about a conditional runner from the crew macros, would that help?

http://www.chaosreignswithin.com/p/macros.html

condtional runner.PNG

OllieClarke

Hi @ayush_mishra, what is the error you're getting? I don't get any errors when I output a sql query with no records

ayush_mishra

@OllieClarke snapshot below. I am applying filters in upstream process which contains inputs (line with unique/duplicate tool) for In-DB tool. Text input has my SQL query.

ayush_mishra

@aatalai @OllieClarke thanks for sharing your suggestions. I used Union tool and passed test data through Text Input before In-db tool and filtered it out after In-db process.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703