Pattern Designer - Filter Table question

[Chris Ellis]

So I'm trying to filter a table in the pattern designer and having a difficult time getting the results I need. Here is an example of the data:

TableX
col1
col2
col3

TableY
col1

The column in Table Y matches data that exists in, let's say, column 2 of Table X. So, when trying to filter the table, my condition is this:

Source Table: TableX
Target Table: TableX
$TableX[].col2 CONTAINS $TableY[].col1

I expect to get back only those entries in Table X where the value of Table X, col2 contains one of the values in Table Y.

(And while we are on the subject, can someone explain the difference in $TableX[*] vs $TableX[] (one with the asterisk and one without.))

I am relatively new to mapping so its possible I have no idea what I'm doing. Any help would be greatly appreciated.

Regards,
Chris

[johnnyjava · Accepted solution]

So the * means the values of all the rows in this column together.

The [] means "do each row, one at a time"

Your example above would mean: Go through tablex row by row, and compare col2 to tabley's col1 - row by row.

So the comparison is row by row between them.

[Chris Ellis]

Excellent explanation. And I actually resolved my other issue by flipping my condition:

$TableY[*].col1 CONTAINS $TableX[].col2