topic Re: Replacing String1 with String2 in Data Quality

Replacing String1 with String2

Anonymous — Sat, 16 Nov 2024 03:53:29 GMT

Hello everyone,

I am pretty much new here.

I have a sales data which is stored in Postgres at multiple servers. I have retrieved them all and then unite it using tUnite. In my sales data, there is a column called Category_Name which has values like Shirt, Tshirts, Jeans etc. Now the problem is in the database, there are entries like T-shirt, T_shirts and many more. So I want to convert all of them to Tshirt. How can I do that?

Re: Replacing String1 with String2

Anonymous — Tue, 10 Dec 2019 07:15:40 GMT

Hello,

row1.Category_Name.replaceAll("Shirt", "Tshirt")||row1.Category_Name.replaceAll("Jeans", "Tshirt")

The above would replace your values to Tshirt in your string "Category_Name" and you need to define manually in tMap component.

Let us know if it is OK with you.

Best regards

Sabrina