Expression.SyntaxError Jeton Comma attendu

[pedrogarcia]

Hello,

i am trying to remove columns that contain the Suffix of sourceid , I did the code, but it seems it does not work an error message appeared like  Expression.SyntaxError : Jeton Comma attendu. here you have the code below any recommendations,s, please?

= let

= let
Source = Excel.Workbook(File.Contents("C:\Users\kheir\Desktop\pratique Power BI\Formation 1\Product.xlsx"), null, true),

rawdata= Source{[item="clientData",kind="table"]}[DATA]
removeSources=Table.RemoveColumns(Rawdata,List.Select(Table.ColumnNames(Rawdata),each Text.EndsWith(_,"source")))

in
removeSources

[jbwtp · Accepted solution]

Hi @pedrogarcia,

A comma is missing at the end of this line:

rawdata= Source{[item="clientData",kind="table"]}[DATA]

If you put it manually, it should solve the problem.

Kind regards,

John