Tagged with field_counts - Visokio Forums

Idea: Field Counts in Merge/Join and Aggregation Blocks?

cgamolo — Mon, 07 Oct 2013 09:32:46 -0400

It would be nice if the Merge/Join block shows a count of the number of fields you are joining and if the Aggregate block shows a count of the number of fields you have set up to aggregate. This is very useful when doing similar processes and you are choosing the same number of fields. A glance at the counts in the block displays can provide a quick QA to make sure everything is set up properly.

Formulae: Field/Cell direct access functions CELL, etc. (2.8+)

steve — Tue, 17 Jul 2012 09:56:49 -0400

These 4 new formula functions allow you to access arbitrary cells in the data. Also available in scripting.

CELL
FIELDCOUNT
FIELDNAME
FIELDNUMBER

Formula examples to obtain cell values

CELL([Price], 53)

CELL(FIELDNAME(3), CURRENTROW()-1)

Javascript preprocessing example to list all field values


for (n = 1; n<=fieldCount(); n++) {
  out.println(fieldName(n)+": "+cell(fieldName(n), 1)+"
");
}