You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to ignore Header and Footer rows in Flat Files for Data Integration

Received Response
275
Views
4
Comments

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".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!