Hashed File record insertion with default values

[satheesh_color]

Hi All,

I have a requirement to create the hashed file with FileName and RecordCount. FileName as key column.

If the source stage doesn't return any rows the hashedfile needs to create with the records as Filename and recordcount as 0.

If the soure stage return any rows it would create the Filename and the actual record count.

I am facing the issue when the Sourcestage doesn't retun any rows.

Please let me know on how to create a hashed file with the Filename and recordcount as 0 when the sourcestage doesn't retun any rows.



Thanks,
Satheesh

[ray.wurlod]

It can't. You have to design this. Typically detecting zero rows involves two jobs - one to do the testing and a different one to take the action. Control is exerted, of course, via a sequence.