How to compare two columns using partially match result to display
Thanks in advance for your time and help.
I have a requirement to display the report which has 4 columns and two columns partially match. Only need to display the partially matching rows and skip the non-matching.
col1 col2 col3 col4 compare col1 and col4
xyz-1234 bcd lmn 1234 display
xyl-543 hfhf dkjdk 3543 display
xym- 3333 cccc dfdd 11111 skip
How can we achive this in smart reporting?