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?

[M Iftikhar]

@Momiji , To skip a certain number of rows, we typically use an onBefore transform script with something like:

if (source.sys_import_row == 0)
ignore = true; // Try x=0 or x=1 to confirm which works

This way, the row is still processed but ignored, and no error will be thrown.

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 your response. This is what I did actually, but the error is still being thrown.

[Ankur Bawiskar]

@Momiji 

what's your business requirement?

share screenshots of your excel and which rows you want to ignore.

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

[Momiji]

it is like this. I want to ignore the 3rd row.