2 Replies Latest reply: Aug 16, 2011 5:26 PM by Bikash Debnath RSS

    How to apply OR filter between two columns in a table?

      Hi,

       

      I am having an issue with setting OR filter between two columns. I am having one fact table having the following columns and having million of records.

       

      Key

      col1

      col2

      type

       

      We need to do the following steps choose right data set for the business purpose.

       

      1. Filter the total dataset using type column.

      2. The user will select range for the col1 and col2. But these ranges needs to applied on dataset using OR filter (union of col1 & col2)

       

      How do we get OR filter between two column ranges?

       

      Appreciate your early response on this.

       

      Many thanks