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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach