LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: MaxwellDowney

Hi,
I'm looking for a way to Publish ONLY the numeric summary value of a Node (number represented by the green dot), instead of outputting each row. For example:

X-Ref Node
8 Left Orphans from SourceA
226 Matches from both sources
10 Right Orphans from SourceB

I want to output a file like:
SourceA = 8
Matches = 226
SourceB = 10

Also, if it makes a difference my data is all text. I hope this makes sense and I thank you for your help in advance!

Max

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ejones

You can add an Agg node to each of the outputs of the X-Ref node that counts the records. The Agg expression needs to be a constant value if you want all the records to contribute to the count instead of counting records in subgroups.

The lines in the report can be built by concatenating strings together in the emit statement. The str() function to cast the Recod Count number to a string. The "+" sign can be used to indicate concatenation but you may prefer the strcat() function.

Add this Agg node to each of the outputs of the X-Ref then Cat the results of the three Agg nodes to put them into one report.

I don't know if this makes any sense so I'm attaching a graph to help clear up any confusion.
Attachments:
SimpleSummary.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: MaxwellDowney

Thanx, this is exactly what I was looking for!