Forum Discussion
How to delete rows that have specific values in a field?
Hello
How can I delete rows (by inserting the right code in the Advanced Editor) so that the rows of the table are deleted if a specific field has any of the values contained in another table's field?
Will that work when I hit refresh? As it will have to refresh the lookup table first before executing the deletion of the rows in the other table.
Thanks!
2 Replies
- AlB
Community Champion
Hi Anonymous
You can just use something like
Table.SelectRows(BaseTable, each <> fieldfromTheOtherTable)
to filter your base table. If you show a sample of both tables (please in text-tabular format) and include/explain the expected result we can get into the details
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
look a bit, it seems they have done a function just to perform this task qui
