I wonder if there is a method for calculating a metric (e.g. sum) per
row (working on a tabular dataset). But, each row contains a different
number of values (i.e. some columns are empty). Can I compute this,
Joachim Jacob, PhD
Rijvisschestraat 120, 9052 Zwijnaarde
Tel: +32 9 244.66.34
Bioinformatics Training and Services (BITS)
In short, you would want to avoid mixing rows of containing a
number of columns or empty values being used in the calculation. So,
this would be possible as long as:
1. There are an equal number of columns per row in the file overall.
This may mean that "null" or empty values have to be padded.
2. Any null or padded values are either not included in the
or are padded with a "0", if that still makes sense for your
If this doesn't seem to meet you needs, perhaps filtering the data
different populations, performing the calculation, then merging the
result is an option (as would grouping the steps into a workflow).
tools such as "Filter" or "Select" with "Cut" and "Paste" would likely