Ability to do CONCAT or SUBSTRING?


We are trying to do some joins where we only need to match a subset of a column, but are unable to do so ;(

Is something like this planned/coming out soon?



There are no short term plans to include these.

I would recommend from a performance perspective to do the substring and concats as part of the ETL process when you load the data. It will make the join processing much more performant (and possible with current software)