Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Problem using an if statement with a column name with a "/" in it

I have a line like this in my query:

 

= Table.ReplaceValue(#"Replaced Value11", each [CBT], each if [Customer Name/Customer ID]= "Sample Name" then "Something" else [CBT],Replacer.ReplaceValue,{"CBT"} )

 

and it generates an error in the if statement pointing to the text prior to the / saying Expression.SyntaxError: Invalid identifier.

 

However, if I change the column reference in the if statement to a column name without a / in it, it works fine.  Can someone explain why it doesn't like the / in the column name?  Will a / in the column name cause problems in other areas?

 

thanks,

Need Help

3 Replies

  • AnkitBI's avatar
    AnkitBI
    Solution Sage
    6 years ago

    Try below using #"Customer Name/Customer ID". 

     

    = Table.ReplaceValue(#"Changed Type", each [CBT], each if [#"Customer Name/Customer ID"]= "Sample Name" then "Something" else [CBT],Replacer.ReplaceValue,{"CBT"} )

    Thanks
    Ankit Jain

    Do Mark it as solution if the response resolved your problem. Do like the response if it seems good and helpful.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks AnkitBI  for the tip.  Do you know why the behavior in the if statement is different for column names with a / and those without?  Should I avoid using / in my column names?

       

      thanks,

      Chad

      • AnkitBI's avatar
        AnkitBI
        Solution Sage
        6 years ago

        Just a Syntax thing to handle special characters in Column Name. Ideally we shall avoid special characters in Name if not necessary.