need a message to output

[suryadev]

My job has a lookup between input and DataBase. If I get records from the database lookup is done between input and Database,records are sent to the output . If no records come out from the database A message should be sent to the target saying"no records found".


Is there any stage which could be used between look-up and target which could be used to generate message to the target if no records are returned?

[keshav0307]

put a transformer in between the lookup and target stage, and if the value from the reference link link is NULL then set the values to "no records found"

[Sainath.Srinivasan]

Or enable to reject mode in the lookup -> column generator with your message -> funnel back with mail stream

[suryadev]

when I use a transformer after look-up I get 18 fields as output from look up.....do i need to create an other column in transformer target for the message or any condition over there?

[anbu]

A message should be sent to the target saying"no records found"
What do you mean by target here? Target database or application ?

[suryadev]

Actually I have two conditions specified in the query used in ODBC.

If the situation arises in any of these conditions no records can be pulled out of the database.

So when these situations arise I mean if condition1 happens msg should be condition1 so no records

if condition2 is the situation then msg should be condition2 so no records.

The target is WISD output.