Skip to Content
avatar image
Former Member

How to compare text data in two columns in webi report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 03, 2017 at 07:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded