i have one csv file,which are having 6 columns.i have another table which are having only one column.
now i want to lookup row by row of a column value with all rows of a column of another table.
my expression is like below.
Var.var1 = "0091" + row1.Bparty == row2.HOTNUMBERHEAD ? row1.Bparty : "91" + row1.Bparty
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables