Does not contain on List

PHOTO EMBED

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