This content has been marked as final. Show 3 replies
I am developing an application in QV, where I am loading 20 files, with more than 15 fields in each file. To avoid writing code for each single file, I am using for loop as most of the fields are same in every file.
For i=1 to 20
let x="File_" & i & ".xls"
But my problem is every month its possible that some fields may miss from 1 or 2 files. Like below:
So if I use the same code:
this will work for file_1 but in case of file_2, its showing error field not found. Is there any way where I can Load field1,field2,field3 for table2 by leaving field4, even if its missing.
I tried using set errormode=0; but it skipped the table 2 entirely, But I want to load the 2nd table without the missing field. Please help.