Skip to contents

Perform a left join on two rez data.frames and change field access status.

rez_left_join.Rd

This is a wrapper for performing left joins (dplyr::left_join()) on Rez data.frames. It only changes the data frame, such as by changing field access values, at the moment. If your desired field access value is "flex", this may serve as a drop-in replacement for mutate. Note that apart from the data.frame to be modified and the data.frame you are joining from, all arguments of dplyr::left_join() must be named.

Usage

rez_left_join(
  df1,
  df2 = NULL,
  ...,
  fieldaccess = "foreign",
  df2Address = "",
  df2key = "",
  fkey = "",
  rezrObj = NULL
)

Arguments

df1

The left data.frame.

df2

The right data.frame.

...

Other functions passed onto dplyr::left_join(), i.e. the columns you will be changing or adding.

fieldaccess

The field access status of the field you're addding, either a single character (to apply to all of the new fields) or a vector of characters for each new field. Note that if you are both modifying and adding fields, only the added fields will have access values changed. So if you're specifying an entire vector of field access values, the best practice in using this function is to separate new-field and added-field mutates, otherwise the code will be difficult to read.

df2Address

The address to the source rezrDF.

fkey

The foreign key to the df2. If not present, I'll guess with the by-line.

rezrObj

The rezrObj object.

Value

resultDF

Details

By default, if no suffix is specified, the suffixes are c("", "_lower"). That is, if you are joining two data.frames, both with a column called 'name', then the left data.frame's column will still be called name in the new data.frame but the right data.frame's column will get called name_lower.

Examples

sbc007$tokenDF = sbc007$tokenDF %>% rez_left_join(
y = sbc007$unitDF %>% rez_select(id, text),
by = c("unit" = "id"),
fieldaccess = "foreign",
df2Address = "unitDF",
fkey = "unit",
df2key = "id",
rezrObj = sbc007)