Straight Table two columns concatenation

[chaithureddys00]

Hi All,

I am trying to get the require column(Final Complaint) in the below table

Complaint	Comments	Final Complaint
"-"	TR	TR
"-"	some	"-"
Missing Bag	TR	TR / Missing Bag
Missing Bag	some	some

I have two columns in my straight table called Complaint and Comments so I need to concatenate and get the required column called Final Complaint and this should be done in design level only, not in script level.

Any quick help is highly appreciated.

Thanks,

Krishna

[isingh30]

I saw similar post like this few minutes ago. There has to be some logic in the requirement. Whatever you are getting in the final column should be based on some criteria. Please work on the requirement part.

Thank you!