How to bulk replace using tReplace

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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. 

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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.

[akumar2301]

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-fi...

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...