Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have many source files in xls format which i recieve every month..
For invoice02.xls
invoice03.xls
..
so on invoice 40.xls
so i load it as invoice*.xls.. now since last month there are variations in columns ..for ex: if there were 10 columns in previous files now i have 9.
is it possible to skip when their is a missing column
Weirdly this has already been asked twice today!
qvd files in same directory with different fields
More advanced control over data load required – where to start?