Append files

Stedemi

Forums

Dear Brian,
quick question about appending.  I have  four databases with 178 columns each (same headers) from 4 different systems. I have tried to append them but keep getting the message that fields are not in the same format. You can only imagine the pain of checking all fields on all dbases. I wonder why Idea's guys don't provide more infos on ALL inconsistent fields.  I had to use excel and then import
is there a way to  take one Dbase as base and have idea compare and change/adjust the fields of other dbases? Or at least provide a list of not-identical fields?
cheers
 
Stefano

rahulsaxena3 Thu, 03/14/2019 - 04:59

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.