Tech Tip: Creating Separate Files for Summarizations

Follow these simple steps to create and export separate files based upon your summarization:

• Open the original file, in this case SAMPLE-CUSTOMERS
  • From the ANALYSIS tab, select KEY VALUE
    • Key: COUNTRY
    • Groups Found: All are automatically selected, or you can choose just a few.
    • Output Prefix: Default is KeyVal, I would suggest COUNTRY in this case.
    • Create a separate database for each unique key
  • The result is multiple files, example:
    • COUNTRY=ARGENTINA
    • COUNTRY=AUSTRALIA
    • COUNTRY=AUSTRIA

Audimated Apps to Save Time & Help with Tedious Project Tasks:

You can always export files one at a time, but if you are working with a larger data set, we recommend using the Excel Export Utility App to save hours of effort.

How it Works: The Excel Export Utility App will display every IDEA file in the current project folder (what can be seen in the File Explorer pane from within IDEA, including the first level of subfolders) and allow the export of any or all of the files into a brand new Excel file, or append them into an existing file of either .xlsx or .xls type. Option buttons ease the selection of these files. Export can occur on a single file, a few selected through lists or a range of files given by the user to avoid selecting dozens one by one.

Visit the IDEA Marketplace to purchase the Excel Export Utility App.