Forum Discussion

Mourad_Analyst's avatar
Mourad_Analyst
Regular Visitor
3 years ago
Solved

Check if substring from column exists inside string in another table column

I have two tables, firstone identifiants, which has id column as below : second table informations, which has information id column as below:   I added a custom column check in identif...
Need Help
  • m_alireza's avatar
    m_alireza
    3 years ago

    Greg_Deckler , correct me if I am wrong but I dont believe Text.Contains will work on its own as it doesnt work with a list of values... ?

    Perhaps something like this instead: 

    =Text.Contains(Text.Combine(informations[informations id]),[id])



AntrikshSharma's avatar
AntrikshSharma
Community Champion
3 years ago

Mourad_Analyst Use this:

AddedCustom = 
    Table.AddColumn (
        ChangedType,
        "Custom",
        ( CurrentRow ) =>
            List.AnyTrue (
                List.Transform ( 
                    identifiants[ID], 
                    (ID)=> Text.Contains ( CurrentRow[information id], ID ) 
                )
            ),
        Logical.Type
    )