Hi I want to load excelfiles (in batches) - and the format it not always consistent, is there a simple way in the loadscript
to check if a column exists or not - and handle that by assigning a blank value, a static, or a some other value from another column.
Thanks for any comment :-)
Have a look here: Re: Load multiple files with some missing some colums
Retrieving data ...