Datastage Complex Logic Code :

If Agency ID >= 90 than flag should be "N" and from that records on wards flag should be "N" till new name and same should be happened for every new name as below shown output .

        Input:

Output:

 Need Code plz. based on below complex requirement please connect or message or comment me in Linkedin or blog.