Philip Treacy
Admin
Forum Posts: 1574
Member Since:
October 5, 2010
October 5, 2010
Offline
Hi Jacek,
After loading the table you can check the value of the NamedRange then use Table.RemoveRows to clear the table but leave the columns intact
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Col1", Int64.Type}, {"Col2", Int64.Type}, {"Col3", Int64.Type}}),
Conditional_Remove = if NamedRange{0}[Column1] = "Yes" then Table.RemoveRows(#"Changed Type",0,Table.RowCount(#"Changed Type")) else #"Changed Type"
in
Conditional_Remove
Regards
Phil
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6834
Posts: 29981
Member Stats:
Guest Posters: 49
Members: 33568
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —