This content has been marked as final. Show 2 replies
if you're using the "Table Files..." wizard to construct the LOAD statement for your Excel, then
- when you get to the stage with the "Enable Transformation Step", press that button. It will then give you a grid view of your data on its 'Garbage' tab.
- Select the row you want to ignore by clicking on its number and the press 'Delete Marked'.
- From there, finish the wizard by clicking Next and/or Finish.
You will then observe that the resulting LOAD statement includes a filter for removing that row every time.