04-10-2017 05:06 PM
Looking for a simple way to combine two values from an external databse to be one keyword.
For example we have the following current SQL Select String
select pid_parcel, street1, lot_parcel, block_parcel, plan_name_parcel, dstlot_parcel, jurroll_parcel
from Parcel_To_Vadim
where pid_parcel='@primary'
and we want the 2nd keyword value to be the full street address which is currently contained in the external database as STREET_NUM1 + STREET_NAME. The current value of street one is the mailing address in our databse not the physical address.
04-11-2017 06:43 AM
Hey Beverly,
This should be possible using an External Autofill Keyword Set. Can you test something like this?
select pid_parcel, RTRIM(street_num1) + ' ' + street_name, lot_parcel, block_parcel, plan_name_parcel, dstlot_parcel, jurroll_parcel
from Parcel_To_Vadim
where pid_parcel='@primary'
I added the RTRIM to remove any trailing spaces after the first column value.
Hope this helps!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.