Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDMEE - Ignore Header Row in File Load?

elwayisgodFeb 25 2019 — edited Feb 26 2019

I have a source file:

Account,CostCenter,Employee,Entity,Job,Location,Property,Version,Period,Year,Amount

OWP_Basic Salary,96510,8672,1,HR Training & Development Dir,0,OWP_Value,OEP_Working,Jan,2018,90738.34

OWP_Basic Salary,80105,4462,1,SD Sr Systems Analyst,0,OWP_Value,OEP_Working,Feb,2018,90634.88

OWP_Basic Salary,80510,8632,1,CO Infrastructure Lead,0,OWP_Value,OEP_Working,Mar,2018,88628.8

When I run the Data Load Rule, I get the green check mark as success.  However there is an error:

[TC] - [Amount=NN] Account,CostCenter,Employee,Entity,Job,Location,Property,Version,Period,Year,Amount

Rows Loaded: 3

Rows Rejected: 1

I'm struggling to find where how I configure the load so it knows the first row of the data file is actually the Header Row and it won't throw this error to confuse everyone.

I tried putting:  HeaderRow=1 in the Expression on the Import Format on the Amount field.   That didn't work.  I'm stumped on how to get this working correctly.

Thanks for any guidance

This post has been answered by JohnGoodwin on Feb 26 2019
Jump to Answer
Comments
Post Details