Gather steps fails for no records

[cy71_shyam]

Hi all , I have an interface where the Spitter/Gather step does not get any records and it fails there .

my step after gather is that I will convert the xml to csv for a file but I don’t want to create a file if there are no records.

1. How can I get gather to be successful if there are no records

2. After how can I stop the file from generating if there are no records

[Sriprasadsbhat]

Hello Shyam,

Yes the solution you have mentioned should work.Other solution would be using enricher ( instaed of Splitter ) and then filterting only valid set of data .

Regards,

Sriprasad Shivaram Bhat

[Sriprasadsbhat]

Hello Shyam,

Before you send the data to Splitter add a router to check if there are no record then what should be done ( if you want to send CSV with only headers then add content modifier & then put those headers only ).

Regards,

Sriprasad Shivaram Bhat

[cy71_shyam]

My situation is i am selecting from EC inside the splitter which I finally gather, now if there is no data which is returned from the select , I encounter issues , should I pass dummy to satisfy gather XML condition and if I do how do I filter before xml to csv conversation ?