How to filter out the first record of a file?
I am using the CSV Filter Records Command, but I am still seeing the first record: How can I filter out the first record?
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 email@example.com.