5. Appendix E: Reports with a Marc Field

Last Updated 11/09/2023

Overview

Sometimes you will want your report to include Marc fields outside of the typical fields that are in the simple record extracts data source. This is possible by joining onto the full record and filtering on tag and subfield and selecting the first, last, max or min value. You will want to use an aggregator transform to prevent bib records from having duplicate rows. At this time, we haven't found a way to include multiple fields without including multiple rows.

Step-By-Step Instructions

We have a simple item list that shows ID, title, and author; it filters on circ lib. We want to add a new display field that will show the Dewey decimal number.

Example report template

To do this, we'll need to join onto the Flattened Marc Fields and create a new filter on the Tag and Subfield.

The Add Fields button is beneath the Filters tab at the bottom of the screen.

The tag of a Dewey number is 082, so we add that as the filter value for the Tag.

Tag value 082

The subfield of the Dewey number is a, so we add that as the filter value for the Subfield.

Subfield value a

We want to add the Marc field's value using an aggregator in case there are multiple values. I used the "first value" transform but any of the transforms underlined in blue are acceptable. If you're ok with duplicate rows you can let the transform be raw.

Transform values First Value, Last Value, Min, Max are highlighted.

Change the column label so that you don't need to memorize what the value of Marc field represents.

Change the column header? window

Dewey numbers have been retrieved from the records.

Example report output

This page was: Helpful | Not Helpful