Forum Discussion

projects's avatar
projects
Regular Visitor
5 years ago
Solved

String match condition in conditional columns not working

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 "At...
Need Help
Tips and Tricks
  • v-angzheng-msft's avatar
    v-angzheng-msft
    5 years ago

    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.

     

  • projects's avatar
    projects
    Regular Visitor
    5 years ago

    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.