I am unable to pass values with special characters or values with spacing in between to a grid variable

Matillion ETL
1

I want to pass values like "AX#' or "Last Name" to the grid variable but it giving error. I tried setting "AX#" as default value but it was giving errors- unrecognised value. I tried enclosing the value within quotes but no success.

2

Could you please share some configuration screenshot for reference to understand the issue?

3

0694G00000SI2gdQAD_0D74G000008ytJISAY
0694G00000SI2gdQAD_0D74G000008ytJISAY1094×452 56 KB

Unable to iterate or pass values with special characters or spacing in between.

4

Have you tried passing the variables in Double Quotes. Also, it's hard to encode Special characters for Excel query. You may need to set some special parameter options while querying Excel data. ​

5

Looking at the screenshot it looks like data type mismatch between the column containing DX#.

check that once

6

The data type is text and if I try passing value 'Last Name' instead of 'DX#' then also getting the same error message. But it works for 'DX' and 'LastName'.