Hi Brian,
I have a scenario where i need to import multiple files and then append to consolidate to one file.
But always i face this problem where the field types do not match. I end up going to each file copying the data type formats to excel and then correct it in other files. Is there any script which can normalise the field types across all files?
padmathiagarajan
Offline
Last seen: 3 years 4 months ago
Joined: 07/02/2016 - 06:26
Hello padmathiagarajan,
One option is to change all the fields to character before appending another option which I have created a script for (http://ideascripting.com/ideascript/append-file-report) is to create a report before hand that will show you all the possible problems which you can then go in and fix. If there are no problems then the script does the append. Check it out and see if it meets your needs.
Brian