list generated by <a rd-options="" href="/link/idxv?package=dwtools&version=0.8.3.9" data-mini-rdoc="dwtools::idxv">idxv</a>, must be produced on the same data.table on which CJI is used.

integer 0 or NA. Default 0 (inner join) to filter data.table.

nomatch

values to filter data.table. For the columns to skip filtering use <code>TRUE</code>, see examples in <a rd-options="" href="/link/idxv?package=dwtools&version=0.8.3.9" data-mini-rdoc="dwtools::idxv">idxv</a>.

To be used inside data.table, same as <a rd-options="" href="/link/CJ?package=dwtools&version=0.8.3.9" data-mini-rdoc="dwtools::CJ">CJ</a> function. In case of not filtering on particular fields pass <code>TRUE</code> value to ..., see examples in <a rd-options="" href="/link/idxv?package=dwtools&version=0.8.3.9" data-mini-rdoc="dwtools::idxv">idxv</a>.

Data Warehouse, Business Intelligence, data integration helpers. Unifies database connectors
to DBI, RJDBC, RODBC, csv. Easy managing multiple simultaneous db connections. MDX like queries on cube class object.
Data modelling helpers, denormalization of star schema and snowflake schema, basic
normalization. And more.

Jan Gorecki

dwtools

Data Warehouse related functions.

CJI function

list generated by <a rd-options='' href='idxv'>idxv</a>, must be produced on the same data.table on which CJI is used.

values to filter data.table. For the columns to skip filtering use <code>TRUE</code>, see examples in <a rd-options='' href='idxv'>idxv</a>.

To be used inside data.table, same as <a rd-options='' href='CJ'>CJ</a> function. In case of not filtering on particular fields pass <code>TRUE</code> value to ..., see examples in <a rd-options='' href='idxv'>idxv</a>.

CJI: Indexed cross join / filter for data.table

Description

Usage

Arguments

Value

See Also

Examples