Data Managment - PBCS - Skip Rows in File load?

User_XUC2I

Hi experts,

I have a file that comes from source system NetSuite in this format.

Can't I have it skip the Header Row?  It's balance sheet, thus I need to have NZP in the Expressions.  Once I do that then it tries to load the header row....

Can't I do an Explicit map of 'Total' to Ignore and then that would eliminate the 'Total' row from loading?

JohnGoodwin

Are you sure it is not skipping the header record, I would have thought it would reject the header because the amount is not numeric. check the log to confirm

You can also look at the skip functionality in the import format - Defining Import Formats for File-Based Mappings

Cheers

John

JohnGoodwin

Are you sure it is not skipping the header record, I would have thought it would reject the header because the amount is not numeric. check the log to confirm

You can also look at the skip functionality in the import format - Defining Import Formats for File-Based Mappings

Cheers

John

User_XUC2I

When I map 'Total' to 'Ignore' it doesn't validate.

If I map 'Total' to 'IGNORE' it validates.  This tool is too finicky .

User_XUC2I

It is skipping it, was throwing me off.  Issue was with the 'Total' row.

I get it to validate when I map 'Total' in Account field to 'IGNORE'.  Must be uppercase for some reason.  I get the validate fish now and the log still has the error but I get the green checkmark which is key for my automation software so it knows it was a success.

Unreal how confusing this is...

User_XUC2I

Skip also works.  Did not know that was available.