Processes that Benefit from Custom Join Rules

Here are some scenarios where it is almost always desirable to update default export methods with custom join rules.

 

1) Fermentation: In this example an upstream step has a 10,000 point time series on each run and a downstream step is used to register samples taken at 24, 48 and 72 hours:

If no custom join rules are specified, Riffyn will join each of the 3 downstream runs to each of the 10,000 time points on the upstream run, for a total of 30,000 rows in the exported data table. By defining a custom join rule utilizing the "elapsed time" property designed onto each step, there will be no more than 3 rows in the exported data table, depending on how many of the elapsed time values specified on the downstream step are exactly the same as the elapsed time values on the upstream run. The full time series can be recovered by removing the custom join rule from the default export method or by saving an additional export configuration without the custom join rule.

 

2) Fluorescence-activated cell sorting (FACS): For example, a 10,000 event series may be written to a single run on an upstream step, while 384 connected runs on a downstream step represent the smaller number of gated events used to inoculate each of the wells of four 96-well plates. 

If no custom join rules are specified, Riffyn will join each of the 384 downstream runs to each of the 10,000 events on the upstream run, for a total of 3,840,000 rows in the exported data table. By defining a custom join rule that matches the values of the "event time" property designed onto each step, there will be no more than 384 rows in the exported data table.

 

3) Single-stage Chromatography: For example, a 1,000 point volume series may be written to a single run on an upstream step, while 30 connected runs on a downstream step represent the 30 fractions of elution buffer collected.

If no custom join rules are specified, Riffyn will join each of the 30 downstream runs to each of the 1,000 volume points on the upstream run, for a total of 30,000 rows in the exported data table. By defining a custom join rule that matches the values of the "elapsed volume" property designed onto each step, there will be no more than 30 rows in the exported data table.

 

4) Multi-stage Chromatography: For example, a 1,000 point volume series may be written to a single run on each of three steps representing the three stages of a multi-stage chromatography process.

If no custom join rules are specified, Riffyn will join each of the 1000 volume points on the first step to each of the 1000 volume points on the second step, and each volume point on the second step to each volume point on the third step, for a total of 1,000,000,000 rows in the exported data table. By defining two custom join rules, one that matches the values of the "elapsed volume" property on the first and second steps and another that matches the same values on the second and third steps, there will be no more than 1,000 rows in the exported data table.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request