Forum Discussion

C4YNelis's avatar
C4YNelis
Icon for Advocate III rankAdvocate III
8 years ago
Solved

Table.InsertRows - Expression.SyntaxError: Invalid identifier.

After spending well over an hour chasing a very stubborn SyntaxError, I found out that the Table.InsertRows function in M Query does not work for columns containing a '+' (I mean the plus sign, not t...
Data Modeling
Reports
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi C4YNelis,

     

    The field name in a record literal has to be an identifier, and vanilla identifiers can't contain plus signs.

     

    However, you can include any characters you want by using an escaped identifier.

     

    [#"Customer+ID" = 2]

     

     

    Best Regards,
    Qiuyun Yu 

C4YNelis's avatar
C4YNelis
Icon for Advocate III rankAdvocate III
8 years ago

Dear v-qiuyu-msft,

 

I just tried your suggestion and it works like a charm. I never knew it was possible to escape a columnname this way. I thought this was a reserved table syntax.

 

Thank you for your time and efforts!

 

Cheers,

Niels