custom_flist | R Documentation |
A list of allocations can be converted to a list of entities, via the
question "who gave to allocations in this list?" A list of entities can be
converted to a new list of entities via the question "Who are the children of
these entities?" And so on. flist
is the general-purpose tool to make
these conversions.
custom_flist(savedlist, custom, from, to, id_type, where = NULL, having = NULL)
flist_(
savedlist,
table,
from,
to,
id_type,
where = NULL,
having = NULL,
schema
)
savedlist |
a listbuilder list or report |
from |
the origin ID field |
to |
the destination ID field |
id_type |
the id_type of the new listbuilder object |
where |
any pre-aggregation conditions (lazy_dots) |
having |
any post-aggregation conditions (lazy_dots) |
table |
the table within which the flist will happen |
schema |
"CDW" by default, no need to change it |
env |
enviornment for evaluating table, from, to, and ... |
To use flist, you have to specify the origin and destination id fields, as
well as the "context" that defines the transformation. The "context" includes
the CDW table that contains both id fields, and any conditions. Example
context: table = d_bio_relationship_mv
,
condition = relation_type_code %in% c("SF", "SM", "DF", "DM"
.
That would describe an output of IDs that are parents of the original ID list.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.