How to ignore Header and Footer rows in Flat Files for Data Integration
Hi team,
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".
Tagged:
0