Help Desk

Submit a ticket My Tickets
Welcome
Login

How to filter out the first record of a file?

Question
I am using the CSV Filter Records Command, but I am still seeing the first record: How can I filter out the first record?

Answer
The CSV Filter Record Command in the Tabular Transformation BizApp expects a proper CSV with headers. As such, the headers can not be filtered or removed by using the Tabular Transformation BizApp . To filter out the first records you have to use the File Utilities BizApp.

  • Use the OneCloud File Utilities BizApp and select the "Strip Lines" Command.
  • In the Lines to Strip field, enter the lines you want to strip. For example, if you want to strip the first line, just enter "1". 
  • Press "Enter" to confirm.

If you need additional support, please contact support@onecloud.io.

Login to post a comment