Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

When filtering rows of data being imported in, how do you create the expression that uses multiple values to limit the data?


Guest

Recommended Posts

I have a table with over 800,000 records, but I only need about 10,000 of those records imported. I would like to use a Transform Data operation to filter the rows based on a list of values; however, I can't find an equivalent of an IN statement in the Expression Builder.

For instance, if you want to limit based on one value you use [COLUMN]='[VALUE]', but what if you want to limit based on multiple values? In SQL, an IN statement is used (WHERE [COLUMN] IN ('A','B','C','D'). How would this be done in the Expression Builder?

Thanks!

Link to comment
Share on other sites

Hi, you can use the in expression even though it was not in the function provided. For example, [Column] in ('A','B','C').

However, I was looking for this solution, I want it to be [Column] in DocumentProperties['Name'] with my document properties = 'A','B' in a string format. With the aforementioned solution is working, but when it comes to document properties, the filter expression is not working. Hope someone could help me on this. Thanks.

Link to comment
Share on other sites

×
×
  • Create New...