Flag changing in tmap

[lmit]

Hi All,

I have a requirement where I need to change flag from y to n based on a condition.my data looks like below
Id;flag
1;y
2;y
1;
My output should be
Id;flag
1;n
2;y
1;y
If ids are same and have a flag value as y then it has to change to n and if the flag is null it has to change to y

Can anyone Suggest a solution, if so would be a great help.

Thanks in advance,
Lmit

[lmit]

hi Manohar,

its working fine with some other changes as per requirements, thanks a lot for your time and support

Thanks,

Lmit 

[manodwhb · Accepted solution]

please give kudos and Accept the solution when you think you're good with it.