How to compare text data in two columns in webi report

[Former Member]

Hello ,

I am looking for a logic where I can compare the two columns Text data .

I have attached a file where examples are there of the comparison.

text-comparison.jpg

In my report I want the rows as a result which are not matching either in column1 or in column 2.So exact matching rows should not appear in the report .

In the attached file only ROW1 is having the exact matching text else all are examples of non-matching texts.

Please let me know the logic/solution for the same.

Thanks

[kohesco · Accepted solution]

hi

create variable: v_Compare = if [Text1]=[Text2]) Then 0 Else 1

Add the variable in your table and filter out the zero's

grtz

Koen