Skip to Content
0

How to compare text data in two columns in webi report

Aug 03, 2017 at 07:10 AM

131

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Koen Hesters Aug 03, 2017 at 07:58 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded