Filter on Calculated Column in Information Designer

[Shri G]

Hello All,

Can somebody help me with how to apply filter on calculated column in information Designer itself

Thanks,

Shri

[Shri G]

HiJose Leviaguirreandfabd,

 

can you please help me with your inputs

 

Thanks in advance!

[Kirsten Smith (she/her)]

Try creating the column using Transform Data/Calculate New Column instead of Insert/Calculated Column, as they are more readily available in the program.

[Kevin Flynn]

The filter in Information designer is used like the "Where" Part of a TSQL query. Depending on what your Database type is it could change the filter. An example would be If on the filter I wanted only those Accounts that are customers.

You could bring in the field that has the Type Customer, then under the expression, you would put

%1 = 'Customer'

You can make filters with additional columns also. They would be under the alias up top (%2, %3).

Once you save the filter you would add the filter to the Information link as a column.

Is the above what you wanted to know