You can translate the question and the replies:

How do I concatenate two columns and use them in the join?

Hi Team, I would like to know, how would I perform the below join condiiton in VDP, how do I concatenate two columns to use them in the join operation. table_a a LEFT JOIN table_b b on a.column_a = concat(b.column_b1,b.column_b2) Regards, Shafeeq
user
20-12-2018 14:09:42 -0500

1 Answer

Hello, In this case you can create a new field in the table_b view, the new field will have [concat](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#concat)(b.columnb1,b.columnb2) as the Field expression(input) and join this new view with one or more views as per the requirement. Hope this helps !
Denodo Team
20-12-2018 17:05:10 -0500
You must sign in to add an answer. If you do not have an account, you can register here