topic Re: Search one column and replace another column with value if matched in Talend Studio

Search one column and replace another column with value if matched

Anonymous — Mon, 03 Dec 2018 23:26:38 GMT

I'm trying to do a search on one column, and if the field matches a pattern or value, then a different column in the row gets a value.

What is the proper way to do this?

Re: Search one column and replace another column with value if matched

vapukov — Tue, 04 Dec 2018 08:32:25 GMT

check tReplaceList make 2 inputs from the same file

Re: Search one column and replace another column with value if matched

Anonymous — Wed, 05 Dec 2018 21:17:37 GMT

This seems like a brutal workaround, why doesn't replace offer separate lookup/replace columns?

I'm also completely unsure how you propose I use treplacelist, what do you mean two inputs?

Re: Search one column and replace another column with value if matched

vapukov — Wed, 05 Dec 2018 21:32:32 GMT

there are many ways could help to achieve the same result, you task - check and choose the best for you (especially when you did not share all information 😉 )

but all of them as described require self-join - multiple use the same table as different source and join them

it could be tMap with main flow and 1-* lookup inputs, it could be tReplaceList, in all cases - as you describe you want to search not in the same row, but in all rows from a different column, so you will need for each row from main flow make a lookup for all rows from lookup columns

Re: Search one column and replace another column with value if matched

Anonymous — Thu, 06 Dec 2018 19:30:15 GMT

Woah, not all rows, the other column is known beforehand and will be in the same row.

Re: Search one column and replace another column with value if matched

Anonymous — Thu, 06 Dec 2018 19:30:54 GMT

Don't need to search all rows, the other column is known beforehand and will be checking a field in the same row.

Re: Search one column and replace another column with value if matched

Anonymous — Thu, 06 Dec 2018 19:37:09 GMT

Given example:

column_1, column_2, column_3
AAA, BBB, CCC
AAA. BBB, CCC
AAB, BBB, CCC

So for each row, if column_1 = "AAA", then column_3 = "DDD", The expected output would be:

column_1, column_2, column_3
AAA, BBB, DDD
AAA. BBB, DDD
AAB, BBB, CCC

Re: Search one column and replace another column with value if matched

vapukov — Thu, 06 Dec 2018 20:12:11 GMT

Hi,

if all in same row, it is simple:

in tMap in col3 put

col1.equals("AAA")?"DDD":col3

Re: Search one column and replace another column with value if matched

Anonymous — Fri, 07 Dec 2018 03:19:17 GMT

Not a bad option, I've used one just like that prior, but is there any way to handle a large amount of them?