Does not contain on List
Thu Feb 06 2025 15:11:27 GMT+0000 (Coordinated Universal Time)
Saved by
@bdusenberry
let
Source = crb3f_production_tracking_shipping,
// Ensure the column is treated as text and handle null values
#"Handled Nulls" = Table.TransformColumns(Source, {{"crb3f_void_fill_type", each if _ = null then "" else _, type text}}),
// Define the list of uppercase words to remove
UppercaseWordList = {"FOAM", "UNKNOWN", "TRAY", "BUBBLE WRAP"},
// Remove rows where the value is fully uppercase AND in the word list
#"Filtered Rows" = Table.SelectRows(#"Handled Nulls", each
not List.Contains(UppercaseWordList, [crb3f_void_fill_type])
)
in
#"Filtered Rows"
content_copyCOPY
Comments