How to ignore Header and Footer rows in Flat Files for Data Integration
Using the new UI of Data Integration. How do you ignore header and footer rows of a flat file? I know with multi-column load you can have it in the expression, but we are just using a single row.
The header row has as an example looks like this: Ledger,Year,Period,Entity,Currency,Account,Amount
I've seen headers skip automatically, but our error log gives a [NN] error as it doesn't recognize "Amount" as a numeric value.
I tried doing a skip Row in the IF and list column 4 with the value of Entity. Tried it as Entity and "Entity".