Forum Discussion
Expression.syntaxerror: token indetified expected
Plz help me, how to tackle this issue that i get when i try to edit a table imported as excel content from powerpivot.
The same error shows up when i hit refresh on the table which is imported from excel file as excel content.
Thanks.
Hi TAUSEEF,
Based on my assumption, your Power Query should be like below, please directly paste it to the Advanced Editor.
let Source = Teradata.Database("HODB", [Query="SELECT ""AC_RNK"".""CHART"".* FROM ""AC_RNK"".""CHART"""]), #"Renamed Columns" = Table.RenameColumns(Source, {{"ACODE", "ACODE"}, {"DESCRIPTION", "DESCRIPTION"}, {"ACODE_TYPE", "ACODE_TYPE"}, {"ACTIVE", "ACTIVE"}}), #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns", {{"ACODE", Int64.Type}, {"DESCRIPTION", type text}, {"ACODE_TYPE", type text}, {"ACTIVE", type text}}) in #"Changed Type"Regards,
Yuliana Gu
10 Replies
Hi TAUSEEF,
Could you please the right side ( drag the bar on the right side) because we cannot see this part in order to find wich token is really missing.
Show the whole image and I can assist.
Ninter
let
Source = #!" let#(cr)#(lf) Source = Teradata.Database(""HODB"", [Query=""SELECT """"AC_RNK"""".""""CHART"""".* FROM """"AC_RNK"""".""""CHART""""""]),#(cr)#(lf) #""Renamed Columns"" = Table.RenameColumns(Source, {{""ACODE"", ""ACODE""}, {""DESCRIPTION"", ""DESCRIPTION""}, {""ACODE_TYPE"", ""ACODE_TYPE""}, {""ACTIVE"", ""ACTIVE""}}),,#(cr)#(lf) #""Changed Type"" = Table.TransformColumnTypes(#""Renamed Columns"", {{""ACODE"", Int64.Type}, {""DESCRIPTION"", type text}, {""ACODE_TYPE"", type text}, {""ACTIVE"", type text}})#(cr)#(lf)in#(cr)#(lf) #""Changed Type"""
in
Source
