ignore row but with error code 800 Unable to resolve target record, coalesce values not present

[Momiji]

In the excel to be imported, I want to ignore the whole row after the header row (only contains instructions).

I tried doing an onBefore script to ignore the row, but the error still appeared. Is this an expected behavior?

[Ankur Bawiskar]

@Momiji 

if you are not using then delete that row manually and then load.

you can specify in the data source what should the header row but in your case it will not create the columns as those are at row 2

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Momiji]

The requirement is from the client. Is it still possible to retain the row without the error showing?

[M Iftikhar]

@Momiji ,

It's working now let me share the code. For testing I updated short description of Incident table.

Sample Excel I created as per your requirement.

In your data source change header to 2.

Now in your On before transform map add code as follows:

You can clearly see 1st row was ignored and 2 incident records were updated.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution and helpful so others can benefit as well.

[Momiji]

thanks for this but it doesn't work on my end

[Momiji]

I tried it in the PDI but still get the error. Did I miss a step?