Forum Discussion

Alexa1104's avatar
Alexa1104
Frequent Visitor
1 year ago
Solved

check if text values from a column are present in another column and return True/False

Hello, I am struggling with a difficult situation (at least for me) and I have been searching for this in various topics but couldn't manage to find a solution. I will explain the topic below: I ha...
Need Help
  • BA_Pete's avatar
    BA_Pete
    1 year ago

    Hi Alexa1104 ,

     

    Try this in a new custom column:

    not List.Contains(Source[Req with NOT Released TCs], [Req with Released TCs])

     

    Gives this output:

     

    Pastable example query:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkxKNjQyVtJRUorViVZKSU1D4gFpqDSIl56RiSoHFQDxsrJzLC0tkeRy8/INDQ3BPCgTJBcLAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Req with Released TCs" = _t, #"Req with NOT Released TCs" = _t]),
    #"Added Custom" = Table.AddColumn(Source, "Custom", each not List.Contains(Source[Req with NOT Released TCs], [Req with Released TCs]))
in
    #"Added Custom"

     

    Pete

SundarRaj's avatar
SundarRaj
Icon for Super User rankSuper User
1 year ago

Hi Alexa1104 , source used is the one mentioned above, you could try this:


Code:
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Req with Released TCs", type text}, {"Req with NOT Released TCs", type text}}),
List = List.RemoveNulls ( #"Changed Type"[#"Req with NOT Released TCs"] ),
#"T/F" = Table.AddColumn ( #"Changed Type" , "T/F" , each List.Contains ( List, _[#"Req with Released TCs"] ) )
in
#"T/F"