Error Filtering Recipients With External Database Table [FDA]

Avatar

Avatar

ersann

Avatar

ersann

ersann

27-05-2019

Hi,

I am trying to query recipients based on some criteria stored in external database. I have joined external table as shown below and selected columns which will be imported, but when I test the query I am getting error below. Is there something am I missing?

XTK-170036 Unable to parse expression '[temp:[camp].[Loan]:@CIF]'.

1760756_pastedImage_0.png

1760757_pastedImage_1.png

1760758_pastedImage_4.png

1760764_pastedImage_8.png

Accepted Solutions (0)

Answers (2)

Answers (2)

Avatar

Avatar

pierrec70731455

Avatar

pierrec70731455

pierrec70731455

27-05-2019

Hi,

your table name is weird. just keep it simple and use alphanumerical characters and if you want to separate words just use camelcase or underscores.

Kind regards,

Pierre

Avatar

Avatar

ersann

Avatar

ersann

ersann

27-05-2019

Hi pierrec70731455

My table name is 'Loan', schema name is 'camp' (like dbo). This table exists on remote mssql server.