I have a case where multiple files represent a data source. On each file, the columns that I'm interested for my base view are present, but the files do not have the same column order.
Because of this and selecting to ignore errors, will result that those files having different number of columns will not be parsed by Denodo, resulting on missing data.
Again, I'm not interested to get the columns that are different only the columns that I know exist on all the files on that folder.
Is there a way to specify which columns are to be selected on the derived view or any other way to avoid Denodo to stop the files which have different number of columns?
Thanks and regards,