I have a huge data with 1794607 records in it with 7-8 different columns in it. Here's the business case which is required,
In one of the column, there are many values which represents the data. I need to make all names prefixed with xe, ge,et and irb and omit the other ones.
How to achieve this logic ? Could someone please help me on the same.