I have a question as in SSIS I am using excel file source and in one of the columns I need to define attributes of that dimension. In order to do that I have to apply logical operator but it is returning the results in boolean i.e., either true false or '0' or '1'. However I want the numbers to be displayed after logical operator is applied. So, Sales column in showing data as :
And logical operator will work as
Sales>= 0 && Sales<=99 should be in "a. 0-99"
Sales>100&&Sales<199 should be in "b.100-199" and so on.
Currently I am using Derived Column but it is showing results in boolean form as mentioned above. But I want the numbers to be categorized for Sales. Please guide.
Thanks in advance.
P.S. Currently Sales' column is of integer data type but can be changed