Skip to main content
ProQuest LibGuides Banner ProQuest LogoProQuest LibGuides homeProQuest LibGuides home

ProQuest Dialog: Support Materials

Learn more about the ProQuest Dialog platform

ProQuest Dialog Youtube Videos

Excel Output Changes - February 2018

Excel Output changes – Drug Pipeline Databases

Changes implemented to improve the export from AdisInsight: Drugs and IMS R&D Focus – specifically. Changes may be noticeable elsewhere too

         Existing column names changed

  • Drug Company              Company information (see also New columns, below)
  • molecularFormula         Molecular Formula
  • mechanism                    Mechanism Of Action
  • route                              Route Of Administration
  • highestPhase                 Phase Of Development (Highest)
  • devPhases                     Phase Of Development (see also New columns, below)

        New columns introduced

  • Subfields of Company Information
    • Company Information – Name
    • Company information – Type
    • Company information – Role (now includes also Licensee and Originator)
    • Company information – Country/Region
  • Subfields of Phase Of Development
    • Phase Of Development - Phase
    • Phase Of Development - Country/Region
    • Phase Of Development - Indication
    • Phase Of Development - Route Of Administration
    • Phase Of Development - Formulation
    • Phase Of Development - On Fast Track
    • Phase Of Development - Qualifiers And Comments
  • Other new columns
    • Substance
    • Generic Name
    • Synonym
    • Molecular formula
    • Therapeutic Class
    • Indication
    • Drug Status
  • One-to-Many
  • AdisInsight: Drugs and IMS R&D Focus ONLY now support 'One-to-Many' functionality
    • Company Information
    • Phase of Development
    • References (Adis only)
  • These fields contain multiple values per record that were previously hidden in Excel
  • Implementation of One-to-Many allows EACH value to be displayed on individual rows and columns to enable filtering and sorting.