Append files

13 posts / 0 new
Last post
rahulsaxena3
Offline
Joined: 01/09/2018 - 14:02

Hi Brian,
I've been using your script to append multiple files in one pass which changes all the fields to character. But there is one small glitch, rather than just appending the databases selected, it ends up opening all the databses in the project folder directory and appends all of them together.
I have tried & tested it extensively, from my experience if there are around 10 files with no virtaulf fields it works fine, otherwise it just appends all the databases in the directory togther.
The only solution to this problem is that if i copy paste all my databases to append in a new folder within the project folder, then it just appends them. But I'm trying to make an application in IDEA where the user imports the files, they are appended and then he maps it to the pre-defined columns in the logic i have created for multiple KPIs/checks. Post that the user selects the KPIs to be run and runs them. I have stiched together/written all of the code now. But due to this error in the append script here, the consolidated database sometimes created is invalid. 
Would request you to please look into this append script on this page if you can, will greatly help me if you can solve this glitch so the script just appends the databases we  have selected and not all the databses.

rahulsaxena3
Offline
Joined: 01/09/2018 - 14:02

this is the script in question

Pages