topic Re: How to bulk replace using tReplace in Talend Studio

How to bulk replace using tReplace

Anonymous — Mon, 21 Oct 2019 05:06:13 GMT

Hi all,

I have more than 100 data to be replaced the value, and the only thing I know is using tReplace function.

Example:

Is there any quicker way to use the same function? Thanks in advance

Re: How to bulk replace using tReplace

Anonymous — Tue, 22 Oct 2019 06:34:17 GMT

The second option could be using eReplace function in tMap but the this will also be row by row operation. But if you are fetching this from some DB then use DB function to replace these string, that would be faster.

If you could share details on the source of this data or job screenshot, we can still think.

Re: How to bulk replace using tReplace

Anonymous — Tue, 22 Oct 2019 10:15:06 GMT

Hi @Ajinkya_Gonnade ,

Now, I'm using this job, but unsuccessful:

Metadata Equipment:

Field_id:

In the end, the database needs to display BAKA as 1, ANSI as 2 and BOKR as 3.

Re: How to bulk replace using tReplace

Anonymous — Wed, 23 Oct 2019 05:33:48 GMT

I don't see other option but again, if you are using a DB use sql to perform same operation that would be faster.

Re: How to bulk replace using tReplace

Anonymous — Wed, 23 Oct 2019 05:36:39 GMT

Can you give me an example on how to use the sql command at DB?

Re: How to bulk replace using tReplace

Anonymous — Wed, 23 Oct 2019 06:28:22 GMT

Hi,

A simple join query will suffice here.

According to your second screenshot (using lookup table). Eg.
select
A.Feild,
B.ID,
A.*
from metadata_equipment A
left join
Feild_id B
on A.Feild= B.Key

According to your first screenshot (using defailt value). Eg.
select
regexp_replace(amount,'.',',') as amt,
street,
name,
firstname
from TABLE1

check if u can leverage regexp_replace() function.

Re: How to bulk replace using tReplace

akumar2301 — Wed, 23 Oct 2019 06:33:00 GMT

Hello ,

I see that you have schema column name in replacement list. So it makes your requirements dependent on schema column name.

If need to use some java coding here if this the case

1) for open studio , you need to use reflect class
https://community.talend.com/t5/Design-and-Development/resolved-Use-tJavaRow-to-get-fieldname-and-fieldvalue/td-p/95362

2) for licence version , dynamic schema
Could Help
https://community.talend.com/t5/Design-and-Development/How-to-extract-and-map-dynamic-fields-in-tmap/td-p/135153