Forum Discussion
How to Filter Columns from a binary
Hi guys, need some help on this I have imported data source from a folder containing 2 excel workbooks. So far it has been working well until the last step which is to filter to keep the columns ...
each keyword is missing. Use below Table.SelectRows
Table.SelectRows([Custom.2], each [Column4] <> "Yearly")
let
Source = Folder.Files("C:\Users\achia\OneDrive - Lenovo\Desktop\Lenovo\Payroll\Data Cleansing"),
Custom1=#table(
3,
List.TransformMany(
Source[Content],
each List.TransformMany(
Excel.Workbook(_)[Data],
each Table.ToRows(
Table.SelectRows(Table.RemoveLastN(Table.Skip([[Column2],[Column3],[Column4]],9),17),each not Text.StartsWith(Text.From([Column4]??""),"Yearly"))),
(x,y)=>y),
(x,y)=>y
)
)
in
Custom1