I am getting the issue 'token comma expected' in advanced query editor. Selecting 'show error' highlights "in" on the second last row - can anyone advise how to fix this?
@v-frfei-msft pls help. Thanks a lot
let
Source = Excel.Workbook(Web.Contents("https://esquel-my.sharepoint.com/personal/dungnthi_esquel_com/Documents/L%E1%BB%8Bch%20xe.xlsx"), null, true),
Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"BUYER", type text}, {"LOT NO/JO #", type text}, {"STYLE ", type text}, {"PO ", type any}, {"PO QTY (Pcs)", Int64.Type}, {"BUYER PO DATE", type date}, {"EX_FACTORY DATE", type date}, {"CUT-OFF AT HAI PHONG", type datetime}, {"CUT-OFF AT FACTORY", type datetime}, {"CBM", type number}, {"VVMV- THÔNG TIN XE", type text}, {"SHIPMENT NO", type text}, {"CONT TYPE - SHIPPING LINE", type text}, {"WAREHOUSE", type text}, {"SHIP MODE", type text}, {"PIC", type text}, {"Status", type any}, {"Remark", type any}, {"PO loading sequence", type any}, {"Image shipmode", type any},
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each true),
#"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows",{{"CUT-OFF AT FACTORY", type time}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type1", each true)
in
#"Filtered Rows1"
