How to compare one column value with another table column

[Anonymous]

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 

[Franz3]

Sorry, i really don't understand what you want to do :
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.

[Anonymous]

@ Fwandz: I want to search [font=Verdana, Helvetica, Arial, sans-serif] row1.Bparty[/font] column value with all rows of[font=Verdana, Helvetica, Arial, sans-serif]  row2.HOTNUMBERHEAD[/font].if it succeed then print the  [font=Verdana, Helvetica, Arial, sans-serif] row1.Bparty[/font] column value otherwise it should print [font=Verdana, Helvetica, Arial, sans-serif] "91" + row1.Bparty[/font] in output.
i am using below expression.but condition is not getting true.
Var.var1 = "0091" + row1.Bparty == row2.HOTNUMBERHEAD ? row1.Bparty : "91" + row1.Bparty

[Franz3]

"0091" + (row1.Bparty.equals(row2.HOTNUMBERHEAD )? row1.Bparty : "91" + row1.Bparty)