Forum Discussion
IF Contain function value
I need to create a new column called "Job Group" based on the "EE List.Job" list.
If the cell contain HSS, RN, Clinician from the EE List.Job, then the new column of the corresponding row shows "HSS", "RN", "Clinician".
Thanks in advance!
Hi Sandie_Fong Try below code in power query advance option:
= Table.AddColumn(#"PreviousStepName", "Job Group", each if Text.Contains([EE List.Job], "HSS") then "HSS" else if Text.Contains([EE List.Job], "RN") then "RN" else if Text.Contains([EE List.Job], "Clinician") then "Clinician" else null)Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar Hafiz
4 Replies
Hi Sandie_Fong Try below code in power query advance option:
= Table.AddColumn(#"PreviousStepName", "Job Group", each if Text.Contains([EE List.Job], "HSS") then "HSS" else if Text.Contains([EE List.Job], "RN") then "RN" else if Text.Contains([EE List.Job], "Clinician") then "Clinician" else null)Hope this helps!!
If this solved your problem, please accept it as a solution and a kudos!!
Best Regards,
Shahariar HafizThank you! I was trying to write this myself but have error with expression. Yours worked.
Table.AddColumn(Source, "Job Group", each List.Intersect({Text.Split([EE List.Job], " "), {"HSS", "RN", "Clinician"}}){0}?)You c an use
if Text.ContainsAny([EE List.Job], {"casee 1","casee 2","casee 3","casee 4"}) then ................. else ...........
