topic Re: How to compare one column value with another table column in Talend Studio

How to compare one column value with another table column

Anonymous — Wed, 29 Jun 2016 05:35:37 GMT

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

Re: How to compare one column value with another table column

Franz3 — Wed, 29 Jun 2016 09:46:41 GMT

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.

Re: How to compare one column value with another table column

Anonymous — Wed, 29 Jun 2016 10:29:37 GMT

@ 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

Re: How to compare one column value with another table column

Franz3 — Wed, 29 Jun 2016 12:52:13 GMT

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