Support Questions
Find answers, ask questions, and share your expertise

how to restrict the rows from the file while creating external table?

New Contributor

Hi ,

Can anyone tell me that if there is any option to restrict the rows from the file (.csv) while creating the external table.

Thanks,

Saravanan

2 REPLIES 2

Re: how to restrict the rows from the file while creating external table?

Super Collaborator

@Saravanan Appanasamy Can you explain what you mean by "restrict the rows"?

Re: how to restrict the rows from the file while creating external table?

New Contributor

Hi James,

The requirement is like, to load only the header row (first row) of each files in the directory, which is mapped to the external table.

Would that be possible?

Thanks,

Saravanan