Import Multiple Excel files and convert to IMD files

William Yong

Forums

Hi there,
I require a script that could perform the following tasks:
- special purpose function that could read and import mutiple Excel files in a folder or directory,
- appends all the Excel files and return a single IMD file, the files are stored in an array,
- display the appended single IMD file into a pivot table.
Lastly, can I perform an extraction inside a pivot table? Because I could not find any area for me to perform extraction under the pivot table view, that is, I'm interested to view the total more than 2 (data field in pivot table: count) only instead of the overall database.
Appreciate to get some sample script here or some guidance or pointers on how to prepare the script.
Cheers, William

Brian Element Mon, 05/23/2016 - 15:06

Hi William,

You can use my multiple file import script to get an idea on how to import multiple items from a folder.  The script puts all the items into an array that you could then use to append them together.  Also IDEA will create the script for you to create a pivot table.

Sorry you can't extract from within a pivot table, you will need to do the extract prior to creating the pivot table.

Thanks

Brian