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