Issue Treating nulls in Conditional Column of Type Any

[han_rj]

Hi All,

I have a column Name of which I am extracting only rows that contain words like "Additive" using conditional column , I have attached the M-Query code for the same. The issue I am facing is that Null are getting transformed as Errors.Please may I have help know where I am wrong.

[Anonymous]

Hi @han_rj,

Thanks @Akash_Varuna  and @wdx223_Daniel  for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[Akash_Varuna]

Hi @han_rj , I think Text.Contains function expects a non-null value, and when it encounters a null , it throws an error Could You please try this 
Table.AddColumn(
#"Changed Type",
"Custom",
each if [Names] <> null and Text.Contains([Names], "Additive") then [Names] else null
)
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[wdx223_Daniel · Accepted solution]

if Text.Contains(Text.From([Name]??""),"Additive") then [Name] else null