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?
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?
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
Don't need to search all rows, the other column is known beforehand and will be checking a field in the same row.
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
if all in same row, it is simple:
in tMap in col3 put
Not a bad option, I've used one just like that prior, but is there any way to handle a large amount of them?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.