...
- Click 'OK'. This will populate a new column with a number representing the number of matching lines found in ListB
- Facet on the new 'ListB Comparison' column to find those lines in ListA that do not appear in ListB (a zero in the column) based on a title.identifier.issn match, and select the 'true' facet to ensure you have filtered the list to only those for which this first step did not find a match
- Click on the column header of the new 'ListB Comparison' column and choose 'Edit Cells' -> 'Transform ...'
- In the 'Expression' box enter the text:
- cells["title.identifier.eissn"].cross("ListB","title.identifier.eissn").length()
- When you click 'OK', this will use the contents of the title.identifier.eissn column in ListA to check for matches in the title.identifier.eissn column in ListB
| Anchor | ||||
|---|---|---|---|---|
|
The above examples use ISSN to lookup between two sheets because generally ISSNs are used consistently. While it is sometimes necessary to do some small changes to ensure consistency between ISSNs (e.g. adding hyphens if they are missing, or ensuring both sets of ISSNs use uppercase 'X' - both easily fixed via Quick Fix Transformations), generally you can use ISSNs for comparisons without a lot of effort. However sometimes you want to compare using title strings, and as these vary much more between different journal lists simply using the title 'as is' can lead to you missing matches.
...