This content has been marked as final. Show 2 replies
You have a header parameter in the file datastore. You can provide any number to skip rows from top of the file. For footer you can create a filter in staging area.
Filter coould be something like this.
where source_alias.source_column not like '%FOOTER_OR_ANY_VALUE_AS_PER_YOUR_REQ'
1. open your model (source)
2. go to files
3. set 1 under heading(Number of lines).
you may skip your header by doing this.
for footer you may follow Bhabani's solution as i haven't need ever.
your problem wil get solved.