How to create new files for every unique department in source

[SRai22]

Hi,

I want to create new text files with every new department in the source input. Suppose I have x departments row in my source input,x new file whose filename is department name.

Thanks.

[Anonymous]

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina