Returns a table with data included based on a pipe bar delimited inclusion string
SppFilterTableByInclusionList([Table Array],[Column],[Inclusion List],[IncludeHeader])
Where:
Table Array is a Table array (such as the data in a standard table, or the result of a QueryDataValues function).
Column is the column on which to search for inclusions Number starting at 1 for the first column.
Inclusion List is a Pipebar(|) delimited list of inclusion text.
IncludeHeader is TRUE to include header values in the returned table.
| Rule | Result | Meaning |
|---|---|---|
| SppFilterTableByInclusionList(DwLookupCustomers,5,"USA|United Kingdom",TRUE) | {"FirstName","SecondName","Company","City","Country";"Jeff","Beach","Stromann Roofing LLC","Columbus","USA";"Thomas","Jackson","King LLC","San Francisco",""USA";"Sam","Jones","Cork & Sons","Cardiff","United Kingdom";"Martin","Biddiss","Howell West Ltd","London","United Kingdom";"Patrick","Dishman","Harber and Dietrich","Charlotte","USA";"Ivett","Oaks","Cartman Group","Dumfries","United Kingdom"} | The returned array is a new table containing only results that match with the items specified in the inclusion list for the specified column. |
This is the table that will be filtered to only show data that matches the inclusion list.
| FirstName | SecondName | Company | City | Country |
|---|---|---|---|---|
| Jeff | Beach | Stromann Roofing LLC | Columbus | USA |
| Thomas | Jackson | King LLC | San Francisco | USA |
| Sam | Jones | Cork & Sons | Cardiff | United Kingdom |
| Juliette | Dobois | Marquardt Pouros | Lyon | France |
| Isabella | Wem | Bayer Welch | Velbert | Germany |
| Martin | Biddiss | Howell West Ltd | London | United Kingdom |
| Freddie | Milleton | Hill Ltd | Toronto | Canada |
| Patrick | Dishman | Harber and Dietrich | Charlotte | USA |
| Ivett | Oaks | Cartman Group | Dumfries | United Kingdom |
| Tobe | Hellyar | Schneider Manz | Berlin | Germany |