Forum Discussion

NickzNickz's avatar
NickzNickz
Helper IV
2 years ago
Solved

Query Token Literal Expected Error

Hi ... 

I have reciece an error as below. How can i resolve the error ... 

 

 

 

 

let
    //Get list of files in folder
    Source = Folder.Files("imagas_path"),
    //Remove unnecessary columns
   RemoveOtherColumns = Table.SelectColumns(Source,{"Content", "Name"}),
    // Creates Splitter function
    SplitTextFunction = Splitter.SplitTextByRepeatedLengths(30000),
    //Converts table of files to list
    ListInput = Table.ToRows(RemoveOtherColumns),
    //Function to convert binary of photo to multiple
    //text values
    ConvertOneFile = (InputRow as list) => 
        let
            BinaryIn = InputRow{0},
            FileName = InputRow{1},
            BinaryText = Binary.ToText(BinaryIn, BinaryEncoding.Base64),
            SplitUpText = SplitTextFunction(BinaryText),
            AddFileName = List.Transform(SplitUpText, each {FileName,_})
        in
            AddFileName,
    //Loops over all photos and calls the above function
    ConvertAllFiles = List.Transform(ListInput, each ConvertOneFile(_)),
    //Combines lists together
    CombineLists = List.Combine(ConvertAllFiles),
    //Converts results to table
    ToTable = #table(type table[Name=text,Pic=text],CombineLists),
    //Adds index column to output table
    AddIndexColumn = Table.AddIndexColumn(ToTable, "Index", 0, 1)
in
    AddIndexColumn

 

 

 

 

 

Regards,

Nickz Nickz

 

 

  • Hi NickzNickz ,

    Thanks for the information you have given.

    After analysing the code you provided, we found that in the statement "ConvertOneFile = (InputRow as list) =>", "&gt" means ">" in HTML but it does not work in M language. This is probably a transcoding error that occurred during the copying of the code.
    The corrected line of code should read:

    ConvertOneFile = (InputRow as list) =>

    In addition, we recommend avoiding the use of multiple "let... in..." .

    Hope it helps!

     

    Best regards,
    Community Support Team_ Joseph Ji

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • NickzNickz 

    It seems, you have use =&gt here the correct syntax should be 

    ConvertOneFile = (InputRow as list) =>

  • Hi NickzNickz ,

    Thanks for the information you have given.

    After analysing the code you provided, we found that in the statement "ConvertOneFile = (InputRow as list) =>", "&gt" means ">" in HTML but it does not work in M language. This is probably a transcoding error that occurred during the copying of the code.
    The corrected line of code should read:

    ConvertOneFile = (InputRow as list) =>

    In addition, we recommend avoiding the use of multiple "let... in..." .

    Hope it helps!

     

    Best regards,
    Community Support Team_ Joseph Ji

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.