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.

     

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
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.