Find and Replace

[sriniprad08]

Hi Team,

Hope you are well. I need help. I am working on a problem where i have find if the "Kundra" column is present in "Abhinav" if yes then create a new column with the match "Kundra_match.

Please find attached the sample file.

Thanks 

Sri

[Robin_McIntosh]

What are you looking to find?  If line by line values match?  If any value in Abhinav is in Kundra?  Or are you saying that if the input file has a column labeled Kundra, then add the new column labeled Kundra Matching?

[sriniprad08]

Thank you @Robin_McIntosh . I am trying to find if any value Kundra is in Abhinav. if yes then create a new column with "yes" else "No"

[ShankerV · Accepted solution]

Hi @sriniprad08 

One way of doing this.

As there are not matching values, all are null.

Hence adding one value in Kundra as 2715 to show the value is populated correctly or not.

Many thanks

Shanker V

[sriniprad08]

Hi @ShankerV ,

Many thanks . Really appreciate your help. this is perfect.

cheers,

Sri

[ShankerV]

Hi @sriniprad08 

Glad the solution worked for you!!! Happy to help!!!!