interlace

interlace_sql

The function "interlaces" the queries and combines their validity time axes (valid_from and valid_until)
onto a single time axis.
<code>interlace_sql()</code> is deprecated in favor of <code>interlace()</code>

A collection of functions that enable easy access and updating of a database of data over time.
More specifically, the package facilitates type-2 history for data-warehouses and provides a number
of Quality of life improvements for working on SQL databases with R.
For reference see Ralph Kimball and Margy Ross (2013, ISBN 9781118530801).

Rasmus Skytte Randløv

SCDB

Easily Access and Maintain Time-Based Versioned Data
(Slowly-Changing-Dimension)

Marcus Munch Grünewald

Lasse Engbo Christiansen

Statens Serum Institut 

interlace function

<dl><dt>tables</dt>
<dd>(<code>list</code>(<code>tbl_dbi(1)</code>)) 
The historical tables to combine.</dd>
<dt>by</dt>
<dd>(<code><a href="/link/character()?package=SCDB&version=0.4.1" data-mini-rdoc="SCDB::character()">character()</a></code>) 
The variable to merge by.</dd>
<dt>colnames</dt>
<dd>(<code>named list()</code>) 
If the time axes of validity is not called "valid_to" and "valid_until" inside each <code>tbl_dbi</code>,
you can specify their names by supplying the arguments as a list:
e.g. c(t1.from = "\&lt;colname\&gt;", t2.until = "\&lt;colname\&gt;").
colnames must be named in same order as as given in tables (i.e. t1, t2, t3, ...).</dd></dl>

Arguments

Combine any number of tables, where each has their own time axis of validity — interlace

<dl>

<dt>tables</dt>
<dd>(<code>list</code>(<code>tbl_dbi(1)</code>)) 
The historical tables to combine.</dd>


<dt>by</dt>
<dd>(<code><a href='https://rdrr.io/r/base/character.html'>character()</a></code>) 
The variable to merge by.</dd>


<dt>colnames</dt>
<dd>(<code>named list()</code>) 
If the time axes of validity is not called "valid_to" and "valid_until" inside each <code>tbl_dbi</code>,
you can specify their names by supplying the arguments as a list:
e.g. c(t1.from = "\&lt;colname\&gt;", t2.until = "\&lt;colname\&gt;").
colnames must be named in same order as as given in tables (i.e. t1, t2, t3, ...).</dd>

</dl>

interlace: Combine any number of tables, where each has their own time axis of validity

Description

Usage

Value

Arguments