String match condition in conditional columns not working

[projects]

Hello everyone,
I am trying to group the "Attribute" column data (row-wise) by creating a conditional column and pasting the group name against each element depending on what it's name is in the "Attributes" column. But, the problem I am facing is that, if the name of the element is too long and is shown in the form of wrapped text ( shown in two lines one below another)  in that "Attributes" column, the matching string entered in the conditional column does not exactly match with the original name in the attributes column and hence the conditinal column returns a null value. For example, if I am trying to match "Girder Pre Casting LHS Planned Date" in the Attributes column with the string " Girder Pre casting LHS" as a conditional matching string, the output comes as a null value and not the output string that I specified in the condition. Please refer to the screenshot attached for better clarity.   

[v-angzheng-msft · Accepted solution]

Hi, @projects 

Go to the advanced editor and change the match value to "A" & "#(lf)" & "B", note that no space should be left between A and B. In you case, the Value should be: "Girder Pre Casting"&"#(lf)"&"LHS"

my sample:

Please refer to the attachment below for details

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@projects , Try Text.Contains, if that can help in a new column

Refer if needed

Power Query - Text.Contains: https://youtube.com/watch?v=Hs2q6qcrdgU&feature=share

[projects]

Thank You @amitchandak , but I have multiple conditions here and I am not sure if text.contains works for multiple conditions because I have multiple groups and different outputs for different strings matched. Please refer the screenshot below for more information.